1.查找某个节点下面子孙节点
select * from table start with id=1 connect by prior id=pid
2、查找节点的祖先节点
select * from table start with id=5 connect by prior pid=id