yii2 使用hasMay关联查询的问题

Question

$order = Orders::find() ->where(['order_sn' => $order_sn, 'user_id' => Yii::$app->user->identity->id]) ->all(); { "success": true, "code": 200, "message": "OK", "data": [ { "id": "658", "order_sn": "201811088879168432", "user_id": "290", "order_status": 15, "shipping_id": 0, "shipping_name": "", "pay_id": 0, "pay_name": "", "goods_amount": "1067.00", "user_discount": 100, "shipping_fee": "0.00", "pay_fee": "0.00", "integral_money": "0.00", "coupon_id": "0", "coupon": "0.00", "order_amount": "1067.00", "created_at": "1541658432", "pay_time": "0", "shipping_time": "0", "finish_time": "0", "shipping_no": "", "pay_note": "", "ip_address": "127.0.0.1", "region_id": 12, "coupon_code_id": null, "discount_amount": null } ] } ordes关联了多个表但是查询的json数据中只有order表的数据 之前在视图中如果想查询出关联数据 就使用结果集再次调用就行了 例如：$orders->user->email;但是现在是api形式的 要如何处理呢？

Answer 1

$order = Orders::find()
            ->where(['order_sn' => $order_sn, 'user_id' => Yii::$app->user->identity->id])
            ->all();

$data = [];
foreach ($order as $k => $val) {
      $data[] = [
          'id' => $val->id,
          'order_sn' => $val->order_sn,
          'user_email' => $val->user->email,
           ...
      ];
}

return json_encode($data); 

Answer 2

Model文件Orders.php中可以使用fields()方法的：

public function fields()
{
    $fields = parent::fields();
    $extraFields = ['user'];

    return array_merge($fields, $extraFields);
}