/** * @return Role - assigned to User. */ public function getRole() { $roleTable = CoreTables::TABLE_ROLE; $siteTable = CoreTables::TABLE_SITE; $siteMemberTable = CoreTables::TABLE_SITE_MEMBER; return Role::find()->leftJoin($siteMemberTable, "{$siteMemberTable}.roleId = {$roleTable}.id")->leftJoin($siteTable, "{$siteTable}.id = {$siteMemberTable}.siteId")->where("{$siteMemberTable}.userId=:id AND {$siteTable}.name=:name", [':id' => $this->id, ':name' => Yii::$app->cmgCore->getSiteName()]); }