Pagination in yii2 with data grouping, displays the wrong amount?

Question

Yii

There is such a complex query with data grouping and a temporary table

$subQuery = (new \yii\db\Query())
            ->from('pm')
            ->where('user_id = :user_id AND sender_id != :user_id AND status != :status ' . $w . '
            ORDER BY created_at DESC', [
                'user_id' => Yii::$app->user->id, 'status' => Pm::STATUS_DELETE]);
        $query = self::find()->select('id, text, created_at, username, sender_id, user_id, sum(unread) as noread');

        $query->from(['AS `tmp_table` GROUP BY `sender_id` ' => $subQuery]);

in the grid it displays 5 records, correct, but the pagination is not correct,
$count = $query->count(); shows 63
Tell me how to fix it?

Answer 1

show data provider code