It can be used for queries like this in MySQL: `SELECT * FROM `plans` ORDER BY FIELD(`interval`, 'day', 'week', 'month', 'year');`

OrderByField.php

<?php

namespace App\Traits;

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Facades\DB;


/**
 * Traits that eases the use of ORDER BY FIELD with an eloquent model.
 * https://github.com/laravel/ideas/issues/1066
 */
trait OrderByField
{
    public function scopeOrderByField(Builder $query, string $field, array $values)
    {
        $orderedValues = implode(', ', $values);
        return $query->orderByRaw(DB::raw("FIELD({$field}, {$orderedValues})"));
    }
}