姚博文 cte 公用表表达式Common Table Expression

with recursive dic as ( 
  select a.id,a.name,a.parent_id,a.level from country a where  name='internal' and level=1 and type=3
  union all  
  select k.id,k.name,k.parent_id,k.level  from country k , dic c where k.parent_id = c.id 

)select * from dic  ;