查找本级及下级的所有组织的sql
select * from t_org_costcenter subOrginner join t_org_costcenter porg
ON subOrg.flongnumber like porg.flongnumber || '!%'
or suborg.flongnumber = porg.flongNumber
where 1=1
and porg.fid in('45gAAAETsk/M567U','45gAAADoCT/M567U')
查找本级及下级的所有组织的sql
select * from t_org_costcenter subOrg