Getting the row number for the current db entry in Laravel.

gistfile1.txt

This is a very inefficient way to do it once the db is huge.  But it works.  For the example, the user id is 5.

$userId = 5;
\DB::statement('SET @row=0');
$user = \App\Models\User::whereRaw('1=1')
    ->select([
        \DB::raw('@row:=@row+1 as row'), 
        \DB::raw('count(*) as c'), 
        'users.*'
     ])
    ->groupBy('id')
    ->orderBy('c','desc')
    ->get()
    ->filter(function($entity) use ($userId) { 
        return $entity->getKey() == $userId;
    })
    ->first();