select u.login_name, u.user_name, u.mobile_no, role.role_name, w.wh_name,o.org_name
from com_user u,
com_role role,
tb_usc_org o,
com_role_user ru,
tb_usc_warehouse w,
tb_usc_warehouse_user wu
where u.user_id = ru.user_id
and ru.role_id = role.role_id
and u.user_id = wu.user_id
and wu.wh_id = w.wh_id
and u.office_id = o.org_id
order by 2