--根据定岗信息查询,比较准确(不管有没有登录过的人都能查询到,只要定了岗的),但是语句复杂,
SELECT USER_NAME 姓名,ID 人员ID
from sa_staff_info
where ID in
(SELECT USER_ID
FROM SA_STAFF_ROLE
WHERE DEPT_ID IN (select DEPT_ID
from SA_DEPT_DICT
start with DEPT_ID =(SELECT USER_DEPT_ID FROM SA_STAFF_INFO WHERE ID=[:人员ID])
connect by prior DEPT_ID = UPPER_ID))