select a.*, level from adam_departments a start with a.p_dept_id = '0' connect by prior a.dept_id = a.p_dept_id; 你好, 类似于这种的, 有方式实现吗? level是层级, p_dept_id和dept_id是父子关联关系