I have following 3 models
Group
User
Section
the relation in Group Model
'members' => array(self::MANY_MANY, 'User', 'int_user_group(group_id,user_id)'),
Relation in User model
'section' => array(self::BELONGS_TO, 'Section', 'section_id'),
In Update action, of GroupController, the model is loaded by loadModel() method (Generated by CRUD Generator) it only load the group model (lazy loading), now on Group Update form, i need to access related User models of Group along with the Section of each User, can this be done in a single query?
in update view i can access User by $model->members, but how can i access members along with Section here in single query?