select * from grp_dept_t
start with parent_region_id = 'JK'
connect by prior region_id = parent_region_id
注:jk为你要传进去查询的根节点
select * from grp_dept_t
start with parent_region_id = 'JK'
connect by prior region_id = parent_region_id
注:jk为你要传进去查询的根节点