How to insert another one in the dataprovider request?

Question

Yii

There is such a request for gridview

$query = self::find()->where('
        user_id = :user_id AND sender_id != :user_id AND status != :status', 
        [
            'user_id' => Yii::$app->user->id,
            'status' => Pm::STATUS_DELETE,
        ])
        ->groupBy('sender_id')
        ->with(['profile']);

I need to insert another one into this query, I want to know if there is at least one record with status = 0
If there is, then I need to display the corresponding icon in the grid /
how can I insert another nested query here

Answer 1

First get the number of records with status = 0, and then conditionally add a column.

$zeroStatusCount = self::find()->where('
    user_id = :user_id AND sender_id != :user_id AND status = :status', 
    [
        'user_id' => Yii::$app->user->id,
        'status' => 0,
    ])
    ->groupBy('sender_id')
    ->count();