查询父类以上所有数据 select * from plt_org_info start with id =47 connect by prior id = ParentsId 查询父类以下所有节点数据 select * from plt_org_info start with id =47 connect by prior ParentsId = id 转载于:https://www.cnblogs.com/hytqm/p/3466740.html