我有一个解决方案给你，利用卖方模型，而不是发票和使用软件包staudenmeir/雄辩有很多深.

// 1st query produce 2 sellers
$sellers = Seller::whereIn('id', [1, 2])->get()->keyBy('id'); 

// 2nd query product 3 products
$products = Product::whereIn('id', [1, 2, 3])->get()->keyBy('id'); 

        foreach ($sellers as $seller_id => $seller) {
            // run multiple queries depend on how many sellers do you have
            $data = Seller::query()
                ->find($seller_id)
                ->products()
                ->groupBy('product_id')
                ->selectRaw('COALESCE(SUM(qty), 0) AS qty, product_id')
                ->pluck('qty', 'product_id');

            foreach ($products as $id => $product) 
            {
                var_dump('seller ' . $seller_id . ' | product ' . $product->id . ' | qty ' . (isset($data[$id]) ? $data[$id] : 0));
            }

            // counting total of products sold by each sellers
            var_dump('total ' . array_sum($data->toArray()));
        }

这是卖方模型内部的关系

public function products()
{
return $this->hasManyDeep(
                Product::class,
                [Invoice::class, 'invoice_products']
            )
            ->withPivot(
                'invoice_products', 
                ['qty', 'amount']
            )
            ->groupBy('products.id');
}

这个解决方案确实需要运行多个查询，这取决于你有多少卖家。