查询角色ID为1的所有子级角色: select * from T_SYS_ROLE t start with t.ROLE_PARENTID = 1 connect by prior t.ROLE_ID = t.ROLE_PARENTID