如何在yii2的查询中设置GROUP_CONCAT？

Question

我想提出如下查询：

SELECT GROUP_CONCAT(`user_id` SEPARATOR ',') FROM `damages` WHERE `server_id`=2 

在我的主查询：

$q = new Query(); 
    $dataProvider = new ActiveDataProvider([ 
     'query' => Ticket::find()->where(['user_id' => Yii::$app->user->identity->id]) 
      ->andWhere(['in', 'user_id', [$q->select(["GROUP_CONCAT(`user_id` SEPARATOR ',')"])->from('damages')->where(['server_id' => Yii::$app->user->identity->id])]]) , 
    ]); 

它的错误：

Object of class yii\db\Query could not be converted to string

，当改变主查询：

andWhere(['in', 'user_id', $q->select(["GROUP_CONCAT(user_id SEPARATOR ',')"])->from('damages')->where(['server_id' => Yii::$app->user->identity->id])]) 

输出什么也没有。

如何解决此错误？

Answer 1

为andWhere您可以使用文字，其中

$q = new Query(); 
    $dataProvider = new ActiveDataProvider([ 
     'query' => Ticket::find()->where(['user_id' => Yii::$app->user->identity->id]) 
      ->andWhere(" user_id in (SELECT GROUP_CONCAT(`user_id` SEPARATOR ',') FROM damages where server_id = " . 
          Yii::$app->user->identity->id . ");") , 
    ]); 

但看着你的代码可能是你需要

$q = new Query(); 
    $dataProvider = new ActiveDataProvider([ 
     'query' => Ticket::find()->where(['user_id' => Yii::$app->user->identity->id]) 
      ->andWhere(" user_id in (SELECT `user_id` FROM damages where server_id = " . Yii::$app->user->identity->id . ");") , 
    ]);