alihankoc Eyvallah cok tesekkurler
$rank = DB::select(DB::raw('select user_id, score, user_rank
from (
select user_id, score, @user_rank := @user_rank + 1 as user_rank
from (
select user_id, sum(score) score
from results
group by user_id
order by sum(score) desc
) t1, (select @user_rank := 0) t2
) t3
'
));
$rank=collect($rank)->pluck('user_id','user_rank');
. boyle bisey yaptim