原始表:
查询语句:
WITH RECURSIVE cte AS
(
SELECT a.id, a.parent_plant_id FROM t_plant a WHERE a.id='1'
UNION ALL
SELECT k.id,k.parent_plant_id FROM t_plant k INNER JOIN cte c ON c.id = k.parent_plant_id
)SELECT id FROM cte;
查询结果 :
WITH RECURSIVE cte AS
(
SELECT a.id, a.parent_plant_id FROM t_plant a WHERE a.id='1'
UNION ALL
SELECT k.id,k.parent_plant_id FROM t_plant k INNER JOIN cte c ON c.id = k.parent_plant_id
)SELECT id FROM cte;