I have a user model (Uprofile
), a group model (Group
) and a model that connects users with groups (GroupMembership
). The table groupMemberships
has group_id
, uprofile_id
and role
fields.
Uprofile
and Group
both have a hasMany
relation to GroupMembership
. And GroupMembership
has belongsTo
to both.
I want to list Group
with its assigned users and their roles.
How can this be done with CakePHP
? I did not find an appropriate example.