select * from SYS_ROLE_LIST start with parentid = 0 connect by prior id = parentid 转载于:https://www.cnblogs.com/Iyce/p/3910512.html