SELECT g.groupname
FROM utenti AS u
JOIN groups AS g ON g.groupid = u.groupid
WHERE userid = $id