我有一個名為“業務”的模型，一個企業可以提供多種服務。我有另一種模型，稱為“付款”。付款記錄了人們支付的服務費用。一項服務可以有多個付款。我打算根據收到的付款獲取排名前 10 名和排名最差的 10 家企業。下面的代碼工作正常，但效率很低。我必須循環遍歷整個數據才能檢索我需要的信息。有更有效的方法來實現這一目標嗎？$businesses = Business::with(['services'])->get();foreach($businesses as $business){    $id = $business->id;    $name = $business->display_name;    $services = $business->services;    $businessRevenue = 0;    if(count($services)>0){        foreach($services as $service){            $serviceId = $service->id;            $totalAmount = PaymentTransaction::whereHas('invoice', function($query) use ($serviceId){                $query->where('product_code_id', $serviceId);            })->where('amount_paid', ">", 0)->sum('amount_paid');            $businessRevenue= $businessRevenue + $totalAmount;        }    }    $businessArray = (object) array('id'=> $id, 'name'=> $name, 'revenue'=> $businessRevenue);        array_push($transformedBusiness, $businessArray);}$topBusiness = $bottomBusiness = $transformedBusiness;usort($bottomBusiness, function($a, $b) {return strcmp($a->revenue, $b->revenue);});usort($topBusiness, function($a, $b) {return strcmp($b->revenue, $a->revenue);});$topBusiness = array_slice($topBusiness, 0, 10);$bottomBusiness = array_slice($bottomBusiness, 0, 10);return view('report.department_performance', compact('topBusiness', 'bottomBusiness'));