使用eloquent从2个表中检索查询

// User模型
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

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

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

// Order模型
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

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

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

use App\Models\User;

$user = User::find(1); // 根据用户ID获取用户信息
$orders = $user->orders; // 获取用户的所有订单信息

foreach ($orders as $order) {
    echo $order->id;
    echo $order->name;
    // 其他订单字段...
}