sql 递归查找节点

select *
  from (select distinct (modl.moduleid),
                        modl.modulename,
                        modl.uplevel,
                        modl.serialno,
                        modl.url,
                        modl.isleaf
          from sys_userrole t, sys_role r, sys_modulerole m, sys_module modl
         where m.roleid = r.roleid
           and r.roleid = t.roleid
           and m.moduleid = modl.moduleid
           and t.userid = '3345')
where isleaf = 1  -- 1 为是叶子节点 0为否 没显示出来问题在这里
start with MODULEID = 2
connect by prior MODULEID = UPLEVEL
order by UPLEVEL, serialno