如何使用Laravel集合创建嵌套查询

use Illuminate\Support\Collection;

$data = [
    [
        'name' => 'John',
        'orders' => [
            ['product' => 'Phone', 'price' => 1000],
            ['product' => 'Laptop', 'price' => 2000]
        ]
    ],
    [
        'name' => 'Jane',
        'orders' => [
            ['product' => 'Tablet', 'price' => 500],
            ['product' => 'Headphones', 'price' => 100]
        ]
    ]
];

$collection = new Collection($data);

$result = $collection->map(function ($item) {
    $totalPrice = $item['orders']->sum('price');
    return [
        'name' => $item['name'],
        'total_price' => $totalPrice
    ];
});

dd($result);

Illuminate\Support\Collection^ {#xxx
  #items: array:2 [
    0 => array:2 [
      "name" => "John"
      "total_price" => 3000
    ]
    1 => array:2 [
      "name" => "Jane"
      "total_price" => 600
    ]
  ]
}