SELECT t.name, COUNT(ut.id) AS members FROM users_thevels ut RIGHT JOIN thevels t ON t.id = ut.thevel_id WHERE t.user_id = 1 GROUP BY t.name