SELECT u.org_id did ,d.departname departname from t_s_user_org u LEFT JOIN t_s_depart d ON u.org_id = d.ID WHERE u.user_id =:ddto.uid