SELECT group_foo, group_bar
FROM groups, belongs_in
WHERE belongs_in.user_id = ? AND belongs_in.group_id = groups.group_id