oracel根据父级查询子集数据

select LEVEL lv, f2.*
  from F_UNITINFO f2
 where exists (select 1
          from f_userinfo u
         where 1 = 1
           and u.is_valid = 'T'
           and u.user_word = 'SS'
           and u.primary_unit = f2.unit_code)
 START WITH f2.UNIT_CODE = 'U00001'
CONNECT by PRIOR f2.UNIT_CODE = f2.PARENT_UNIT
 order by f2.unit_order asc