日期:2014-05-16 浏览次数:21030 次
select count(*) from tbl_users u where u.id>0 and u.org_id in ( select org.id from tbl_organization org where org.deleted=0 start with org.id in (20776) connect by nocycle prior org.id=org.org_parent_id ) and u.deleted=0