Why doesn't Count(*) as work?

Question

Yii

This is how I write

$top=Watch::find()
                ->select(['fl_serial.*,fl_watch.*,COUNT(fl_watch.active=1) AS total_count'])
                ->joinWith('serial','fl_watch.id_serial=serial.id')
                ->groupBy('fl_watch.id_serial')
                ->orderBy(['total_count'=>SORT_DESC])
                ->limit(10)
                ->all();

then process like this

foreach($top as $post){
     $posts[]=$post->total_count;}

I get `Getting unknown property: common\models\Watch::total_count` how to properly process `COUNT( * ) AS total_count`

Answer 1

Apparently, there is no total_count property in the Watch model, so it needs to be added:
public $total_count;