This was a thousand year old tricky question for me. But no more!
To order a query by a relationship column, you need a few things:
Use the following:
$posts = Post::query() ->withAggregate('user', 'name') ->orderBy('user_name') ->get();
What happens? Give the following:
So you can use the
RELATIONSHIP_COLUMN as an addition to your original query.