数据表
with RECURSIVE cte as
(
select a.* from department a where name='东南片区'
union all
select k.* from department k inner join cte c on c.name = k.parent_dep
)select * from cte;
数据表
with RECURSIVE cte as
(
select a.* from department a where name='东南片区'
union all
select k.* from department k inner join cte c on c.name = k.parent_dep
)select * from cte;