所以，你有这样的代码：

public function update(Request $request, $id)
{
    $order = Order::where('id', $id)->first();

    $request->validate([
        'order_number' => 'required',
        'client_id' => 'required',
        'description' => 'required',
        'productOrder' => 'required',
        'productOrder.*.product_id' => 'required|distinct|exists:products,id',
        'productOrder.*.amount' => 'required|numeric|min:1',
    ]);

    $order->update($request->all());

    foreach ($request->productOrder as $product) {

        $values[] = [
            'order_id' => $order->id,
            'product_id' => $product['product_id'],
            'amount' => $product['amount'],
        ];

        $amount = Product::find($product['product_id']);

        $totalValue = $product['amount'] + $amount->amount;

        $amount->update(['amount' => $totalValue]);
    }
    
    $order->products()->sync($values); //the problem is here

    $orders = Order::all();

    $orders->load('client', 'products');

    return view('orders/index', compact('orders'));
}

它的问题是sync得到错误的ID，因为$values具有数字自动增量ID：0、1、2等等。
您需要传递给sync的是一个ID数组[1, 2, 3]，或者是数组的数组（当您想要更新与该ID相关的列时，例如：[1 => ['amount' => 100], 2, 3].
让我试着修改你的代码来帮助你。
假设您有orders表和products表。您还有一个名为order_product表的透视表，因此您将关系存储在其中。此order_product表具有：

• id
• order_id
• product_id
• amount

因此，您的代码应该如下所示：

public function update(Request $request, $id)
{
    $validated = $request->validate([
        'order_number' => 'required',
        'client_id' => 'required',
        'description' => 'required',
        'productOrder' => 'required',
        'productOrder.*.product_id' => 'required|distinct|exists:products,id',
        'productOrder.*.amount' => 'required|numeric|min:1',
    ]);

    $order = Order::find($id); // I would change this to use implicit binding

    $order->update($validated); // Don't use $request->all(), you are using unvalidated values

    foreach ($request->productOrder as $product) {

        $values[$product['product_id']] = [
            'amount' => $product['amount']
        ];

        $amount = Product::find($product['product_id']);

        $totalValue = $product['amount'] + $amount->amount;

        $amount->update(['amount' => $totalValue]);
    }
    
    $order->products()->sync($values); // Now it will work

    $orders = Order::all();

    $orders->load('client', 'products');

    return view('orders/index', compact('orders'));
}