使用mysql8with recursive进行递归遍历拼接该子节点各个父级名称

with recursive tree1 AS(

select id,org_name,1 as depth from kfzsk_tree
where parent_id=0
union ALL
SELECT t1.id,concat(t2.org_name,'/',t1.org_name) org_name,depth+1
from kfzsk_tree t1
INNER JOIN tree1 t2 on t1.parent_id=t2.id
) 
select * from tree1 where id=5;