How to get the ordinal number of an object from a collection?

Question

Laravel

You need to get
the Objects that belong to the user
With the serial numbers of each object from the entire collection of objects in the specified sorting.
Purpose: to show the user the positions of his objects in the public directory
Code

// Запрос все коллекции
           Project::with(..)
                  ->withCount(..)
                  ->orderBy(..)
                  ->get()
                  // добавляем номер к элементам
                  ->map(function ($item, $index) {
                       $item['number'] = $index + 1;
                       return $item;
                   })
                  // фильтруем по id авторизованного юзера
                  ->where('user_id', $user->id);

Is this the correct way or is there another one? How to integrate pagination into this system?

Answer 1

Too lazy to write code.
Essence.
You need to make a selection with a serial number set in the database dynamically. Something like num_row, I don't remember.
Use this selection as a temporary-table and use this temporary-table to make a selection by user.