@php $investor = content('investor.content'); $topInvestor = App\Models\Payment::where('payment_status',1)->groupBy('user_id') ->selectRaw('sum(amount) as sum, user_id') ->orderBy('sum', 'desc') ->get() ->map(function ($a) { return App\Models\User::find($a->user_id); }); @endphp
image
@foreach ($topInvestor as $top)

{{$top->full_name}}

{{__('Invest Amount')}} {{number_format($top->payments()->where('payment_status',1)->sum('amount'),2) .' '. $general->site_currency}}

@endforeach