SELECT GROUP_CONCAT(T2.name SEPARATOR "->") category_path
FROM (
       SELECT @r AS _id
        , (SELECT @r := parent
           FROM   category
           WHERE categoryID = _id) AS parent_id
        , @l := @l + 1 AS lvl
        FROM   
           (SELECT @r := categoryID, @l := 0 FROM   category WHERE  categoryID = 19) as var,
            category as C 
      WHERE  @r <> 0 ORDER BY lvl DESC) T1 JOIN category T2 ON T1._id = T2.categoryID

select @cid := categoryID, name,
(
SELECT GROUP_CONCAT(T2.name SEPARATOR "->") 
FROM (
       SELECT @r AS _id
        , (SELECT @r := parent
           FROM   category
           WHERE categoryID = _id) AS parent_id
        , @l := @l + 1 AS lvl
        FROM   
           (SELECT @r := categoryID, @l := 0 FROM   category WHERE  categoryID = @cid) as var,
            category as C 
      WHERE  @r <> 0 ORDER BY lvl DESC) T1 JOIN category T2 ON T1._id = T2.categoryID
) category_path
from product

9,   "Toyota Land Cruiser 100",  Автомобили->Toyota
24,  "Lexus GS300",              Автомобили->Toyota
13,  "BURTON Balance",           Автомобили->Toyota
14,  "Samsung R200",             Автомобили->Toyota
14,  "Samsung N100",             Автомобили->Toyota
......