SELECT
    users_2.*
FROM
    users AS users_1
JOIN users AS users_2 ON
    users_2.group_id = users_1.group_id
WHERE
    users_1.user_id = 10000288
ORDER BY users_2.user_id
LIMIT 1