Obtener contar un queryScalar

$count = \Yii::$app->db ->createCommand('SELECT COUNT(*) FROM user;')
->queryScalar();