How to translate sql query from group by to active record?

Question

Yii

There is a working request

SELECT  `u_id` , COUNT(  `u_id` ) AS  `rating` 
FROM  `u_h` 
GROUP BY  `u_id`

There is a desire to transfer it to active record, but I do not understand how to rename a column in it.
I try like this but it gives me an error

$query = U_h::find(); 
            $u_rating = $query
            ->select(['u_id'], [count('u_id') as 'rating'])
            ->from('u_h')
            ->groupBy('u_id')
            ->all();

Answer 1

$query = U_h::find()->select(['u_id', 'rating' => 'COUNT(u_id)'])->from('u__H')->groupBy('u_id')