SELECT distinct `users`.*, `jobs`.`job_title`, `jobs`.`job_name`, `groups`.`description` as `user_group_description`
FROM `users`
right JOIN `users_jobs` ON `users_jobs`.`user_id` = `users`.`id`
LEFT JOIN `jobs` ON `jobs`.`id` = `users_jobs`.`job_id`
LEFT JOIN `users_groups` ON `users_groups`.`user_id` = `users`.`id`
LEFT JOIN `groups` ON `groups`.`id` = `users_groups`.`group_id`
ORDER BY `username`