group()
->users()
->whereNotIn('group_users.role_id', $hiddenRoles)
->selectRaw("
users.*,
(SELECT GROUP_CONCAT(DISTINCT `roles`.`name` SEPARATOR '|') FROM `roles` WHERE `roles`.`id` IN (SELECT `role_id` FROM `group_users` WHERE `group_users`.`user_id` = `users`.`id`)) AS `all_roles`
")
group()
->users()
->whereNotIn('group_users.role_id', $hiddenRoles)
->selectRaw("
users.*,
(SELECT GROUP_CONCAT(DISTINCT `roles`.`name` SEPARATOR '|') FROM `roles` WHERE `roles`.`id` IN (SELECT `role_id` FROM `group_users` WHERE `group_users`.`user_id` = `users`.`id`)) AS `all_roles`
")