How to sort records by hasOne relationship?

Question

Laravel

Hey!
There are 2 entities, users and "labels". They are connected by a one-to-one relationship. I need to select all users by sorting by the label name associated with them. Is there a nice way to accomplish this task, without joins, and similar more complex structures?

Answer 1

return Users::orderByDesc(
    Tag::select('title')
        ->whereColumn('user_id', 'users.id')
        ->orderBy('title', 'desc')
        ->limit(1)
)->get();