通过机构查询该机构下，以及下级机构的人员 id

    select u.usr_cde,u.usr_id_no,u.usr_name,u.usr_tel,u.usr_email from s_usr u where
          usr_bch in ( Select bch_cde  from s_bch where bch_sup_cde = '00080100' union all select '00080100' from dual )