public static function getActivityInfoById($id = '') { $result = Yii::$app->db->createCommand('SELECT *,au.status as user_status FROM ' . self::tableName() . ' au LEFT JOIN ' . Activity::tableName() . ' a ON au.activity_id = a.id WHERE au.activity_id=:id', [':id' => $id])->queryOne(); return $result; }