SELECT ud.id as userId,ud.organization_id,ud.first_name,ud.last_name,ud.image_url,ud.userOrg.name
FROM
(
SELECT * FROM jhi_user ju
INNER JOIN
(
SELECT manager,user_id,organization_id FROM employee e
WHERE role_id in
(SELECT id FROM role WHERE organization_id in
(SELECT id FROM organization o WHERE sales_person_id = 3)
and name = 'NEXCAR_SALES_PERSON' or name = 'NEXCAR_ADMIN' AND (deleted = 0 or deleted is null))
) userOrg ON ju.id = userOrg.user_Id
) ud