Код: Выделить всё
$result = Company::model()->with(
'staffs',
'staffs.phoneStaffs',
'staffs.emailStaffs'
)->findAll(array(
'condition'=> 'staffs.client_id=:idClientId '
. 'and phoneStaffs.client_id=:idClientId '
. 'and emailStaffs.client_id=:idClientId',
'params'=> array(':idClientId' => $idClientId)));