How to sort selection in Laravel by value in table?

Question

Laravel

There is a table:

| id | name    | role  |
|----|---------|-------|
| 1  | John    | admin |
| 2  | Tom     | user  |
| 3  | Paul    | user  |
| 4  | Mikle   | moder |
| 5  | Lindsey | admin |

How to sort so that the field values role​​are in this order when displayed:
1. admin
2. moder
3. user
That is, the collection of users should look like this if you look at the id: [1, 5, 4, 2, 3]

Answer 1

Read about sorting in the documentation. Everything works the same way with eloquent.

Answer 2

In sql it looks like ORDER BY FIELD(role, ‘admin’,’moder’,’user’)
you need to find the same feature in laravel