例子：

$sql = 'SELECT SUM(o.price) as `sum`
        FROM `order` o
        WHERE o.customer_id ='.$profile->id;

$ret = Yii::$app->db->createCommand($sql)->queryScalar();