Full path by path category magento

-- full path by child id
WITH RECURSIVE category_path (id, title, parent_id) AS
(
  SELECT id, title, parent_id
    FROM magedev_seotree
    WHERE id = 17 AND store_id=1
  UNION ALL
  SELECT c.id, c.title, c.parent_id
    FROM category_path AS cp JOIN magedev_seotree AS c
      ON cp.parent_id = c.id
)
SELECT * FROM category_path;

-- sub tree by id
WITH RECURSIVE category_path (id, title, path) AS
(
  SELECT id, title, title as path
    FROM magedev_seotree
    WHERE parent_id = 0  AND store_id=1
	UNION ALL
  SELECT c.id, c.title, CONCAT(cp.path, ' > ', c.title)
    FROM category_path AS cp JOIN magedev_seotree AS c
      ON cp.id = c.parent_id
)
SELECT * FROM category_path ORDER BY path;

-- whole tree
WITH RECURSIVE category_path (id, title, path) AS
(
  SELECT id, title, title as path
    FROM magedev_seotree
    WHERE parent_id IS NULL
  UNION ALL
  SELECT c.id, c.title, CONCAT(cp.path, ' > ', c.title)
    FROM category_path AS cp JOIN magedev_seotree AS c
      ON cp.id = c.parent_id
)
SELECT * FROM category_path ORDER BY path;