//contoh criteria, dengan asumsi di model t_acl_user
$criteria = new CDbCriteria;
$criteria->alias = 'au';
$criteria->select = 'aa.*';
$criteria->join = 'LEFT JOIN t_acl_action aa ON aa.id = au.action_id';
$criteria->addCondition("au.user_group='member'");
return new CActiveDataProvider(get_class($this), array(
'criteria'=>$criteria,
));