I'm trying to alter a remotecontrol function, but I am struggling quite a bit with they Yii framework way of doing things.

in helpers/remotecontrol/remotecontrol_handle.php in list_surveys, I would like the list of surveys to include the owner email and username (currently only returns owner id)

I know this is a join, but I am struggling to see how to do a join. The current code to retrieve the surveys seems to be

$aUserSurveys = $oSurvey->with(array('languagesettings'=>array('condition'=>'surveyls_language=language'), 'owner'))->findAll();

How do I make that JOIN to users table, and select users username and user email as columns to return ?

David