$command = Yii::app()->db->createCommand("SELECT * FROM `authassignment` WHERE userid={
$user_id}
");
$results = $command->queryAll();
$roles = array();
foreach ($results as $result) {
$roles[] = $result['itemname']; }
$this->setState('roles', $roles);