How to count rows on joined table

Forgot your group by:

SELECT groups.userGroupID, userGroup,
       count(users.userGroupID) AS howMany
FROM groups_table AS groups
LEFT JOIN users_table AS users ON users.userGroupID = groups.userGroupID
GROUP BY groups.userGroupID
ORDER BY groups.userGroupID