Laravel Eloquent - Order By Relation macro

eloquent_macro.php

<?php
Builder::macro('orderByRelation', function(string $searchColumn, string $dir) {
            list($relation, $column) = explode('.', $searchColumn);
            $relation_table = $this->getRelation($relation)->getModel()->getTable();
            $relation_foreign_key = $this->getRelation($relation)->getForeignKeyName();
            $query_table = $this->getModel()->getTable();

            $this->select($query_table . '.*')
                ->join($relation_table, $query_table . '.' . $relation_foreign_key, '=', $relation_table . '.id')
                ->orderBy($relation_table . '.' . $column, $dir);
            
            return $this;
        });

Hi, This might help you.

$users = User::get()->sortBy(function($query){
return $query->role->name;
})->all();

$users = User::with(['role' => function ($q) {
$q->orderBy('name', 'desc');
}])->get();

$users = User::select('*')
->orderBy(Role::select('name')
->whereColumn('roles.id', 'users.role_id')
);

You should return $this at the end so you could chain your query together.
For example: you can call ->get() directly on the orderByRelation (orderByRelation('relation.column')->get())

You should return $this at the end so you could chain your query together. For example: you can call ->get() directly on the orderByRelation (orderByRelation('relation.column')->get())

Good catch, forgot to include that. Thanks!