SELECT o.Name AS 'OrganisationName', u.EmailAddress, u.FirstName, u.LastName, u.Status, u.CreatedAt
FROM User u
LEFT JOIN Organisation_User ou ON u.Id = ou.UserId
LEFT JOIN Organisation o ON ou.OrganisationId = o.Id
WHERE ou.OrganisationId = 'RbVYBJSsqsRksbHC'
AND u.Password IS NULL