sql 递归查询

递归父节点

with  diguifu as( select * from aaa where id=22
union all
select aaa.* from diguifu, aaa where diguifu.PID = aaa.id
)
select * from diguifu

递归子节点

with diguizi as(select * from aaa where id=33
   union all select aaa.* from diguizi, aaa where diguizi.id = aaa.pid
)
select * from diguizi