Problem with associations

[eluser]Carmichael[/eluser]
The sql looks like this

Code:

SELECT pm.group_id, pm.permission_id,
       p.id, p.permission, p.category,
       g.name
FROM permissions_map AS pm
INNER JOIN permissions AS p ON p.id = pm.group_id
INNER JOIN groups AS g ON g.id = pm.group_id
WHERE g.id = $groupId