0
votes
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