YII2 DB count results query Simple in the controller or view file add do this: $count =MODEL:: find () ->select([ 'COUNT(id) AS cnt' ]) ->where([ 'field1' => $value1 , ])-> andWhere([ '>' , 'field2' , $value2 ]) - >one()->cnt; And in the model of the table add before this line: public static function tableName() Add public $cnt ; like below: public $cnt ; public static function tableName() {