SELECT group_id AS `Group`,
       count(*) AS `Members IN`
FROM groups_users
WHERE group_id IN
    (
1398209
    )
AND status = 1
GROUP BY group_id