我有 3 個表(食物、訂單和 orderItems)。我想通過 orderItems 和食品獲得用戶的訂單,但我失敗了。這是我現在得到的結果,但我需要獲取食物詳細信息而不是 food_id。[ { "id": 16, "user_id": 2, "total": "12.50", "items": [ { "id": 20, "order_id": 16, "food_id": 1, "quantity": 1, "food_price": "12.50", } ] }]訂單控制器$user = Auth::user();return response()->json($user->deliveredOrders()->with('items')->get());用戶模型public function deliveredOrders(){ return $this->hasMany(Order::class)->where('status', '=', 'delivered');}訂貨型號public function items() { return $this->hasMany(OrderItem::class); }
在 Laravel 中獲取具有 orderItems 和產品詳細信息的用戶訂單
ibeautiful
2023-04-21 15:28:30