oracle中用于循环遍历树形结构中某个节点的字节点的方法
select * from table1 start with id= #{id} connect by NOCYCLE prior id= pId

?