SELECT
user_id,
user_name
FROM
tik_groups_user as a
LEFT JOIN tik_user as b ON a.user_id = b.id
WHERE
a.user_id IN(
SELECT
user_id
FROM
tik_groups_user
WHERE
groups_id = #{groupsId}
)
ORDER BY a.groups_id
SELECT
user_id,
user_name
FROM
tik_groups_user as a
LEFT JOIN tik_user as b ON a.user_id = b.id
WHERE
a.user_id IN(
SELECT
user_id
FROM
tik_groups_user
WHERE
groups_id = #{groupsId}
)
ORDER BY a.groups_id