Yii 2.0 ActiveRecord 查询问题 [ 2.0 版本 ]

$subQuery = (new \yii\db\Query())->from('yn_goods_analyze_shop_by_day')
    ->select([
        'saleroom_sum' => 'sum(gross_margin)',
    ])
    ->where(['between', 'create_date', $startTime, $endTime])
    ->createCommand()
    ->getRawSql();

$query = (new \yii\db\Query())->from('yn_goods_analyze_shop_by_day')
    ->select([
        'saleroom' => 'sum(saleroom)',
        'brand',
        'goods_name',
        'gross_margin' => 'sum(gross_margin)',
        'gross_percent' => "sum(gross_margin) / ($subQuery) * 100",
    ])
    ->where(['between', 'create_date', $startTime, $endTime])
    ->groupBy('spid');

echo $query->createCommand()->getRawSql();