Many to Many and with()

Archives Yii 1.0.x Discussions
1

Hi,

I have the following database tables and relationships:

users - 1 to many <- user_group -> many to 1 - groups

So in Yii i have 2 models, Users and Groups with a Many to Many relationship. My application requires a user to be able to see all the other users they have a relationship with. So a user may belong to several groups and I want to be able to see all of the users friends from all of their groups.

Is it possible to do something like: 

$user->groups->users
or 
Users::model()->with(groups,users)
?

If not I'll bust out the sql!

2

please read http://www.yiiframew…de/database.arr

3

Yeah, confused the hell out of me! Maybe I'm trying to run before I can walk but you couldnt give me an example could you?

4

You may do $user->groups[$i]->users to traverse through the users within the same group of the primary user, but I guess that's not what you want. Probably you should write a plain SQL for such a problem and call findBySql().

5

Thanks Qiang, looping through sounds like it'll work for me. Cheers!