Laravel中三个表的复杂查询

// User.php
namespace App;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    protected $table = 'users';

    public function orders()
    {
        return $this->hasMany(Order::class);
    }
}

// Order.php
namespace App;

use Illuminate\Database\Eloquent\Model;

class Order extends Model
{
    protected $table = 'orders';

    public function user()
    {
        return $this->belongsTo(User::class);
    }

    public function products()
    {
        return $this->belongsToMany(Product::class);
    }
}

// Product.php
namespace App;

use Illuminate\Database\Eloquent\Model;

class Product extends Model
{
    protected $table = 'products';

    public function orders()
    {
        return $this->belongsToMany(Order::class);
    }
}

$user = User::find(1);
$orders = $user->orders()->with('products')->get();

foreach ($orders as $order) {
    echo "订单ID：" . $order->id . "<br>";
    echo "订单日期：" . $order->created_at . "<br>";
    
    foreach ($order->products as $product) {
        echo "产品名称：" . $product->name . "<br>";
        echo "产品价格：" . $product->price . "<br>";
    }
}