php - 如何在joinWith()yii2内部获取基表列

Order and OrderProducts。如何获取订单表列joinWith（）。

      Order::find()
        ->select(['order.*'])
        ->joinWith(['orderProducts' => function($q){
                $q->select("order_id, product_id, product_name, product_price, quantity, CONCAT(order.currency, total_price) AS total_price");
            }])

在上面的查询中，它显示此错误：

 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order.currency' in 'field list'\nThe SQL being executed was: SELECT order.currency, id, CONCAT('http://192.168.1.114:1090/backend/web/images/products/',image) AS image, sku FROM `POS_1hj2gfru`.`product` WHERE `id`='3'"

最佳答案

请用

Order::find()
    ->select(["order.*","orderProducts.order_id" , "orderProducts.product_id" , "orderProducts.product_name" , "orderProducts.product_price" , "orderProducts.quantity" , "orderProducts.CONCAT(orderProducts.order.currency, orderProducts.total_price) AS total_price"])
    ->joinWith('orderProducts', false)
    ->asArray()
    ->all();

关于php - 如何在joinWith()yii2内部获取基表列，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/36742144/