php - How to order by many-to-many relationship Laravel Eloquent

I have many-to-many relationship users|pivot|task I need to order records by pivot table column(role) and by user table column(name). Ordering by pivot works, but order by users doesnt. Please give any advice how to fix this

Job model

public function users(): BelongsToMany
    {
        return $this->belongsToMany(User::class,'user_job')
            ->using(UserJob::class)
            ->withPivot('role')
            ->withTimestamps();
    }
Copy code

User Model

 public function jobs(): BelongsToMany
    {
        return $this->belongsToMany(Job::class,'user_job')
            ->using(UserJob::class)
            ->withPivot('role')
            ->withTimestamps();
    }
Copy code

Repository

return User::find($dto->getUserId())
            ->jobs()
            ->where($dto->getFilters())
            ->with('users')
            ->orderBy($dto->getSortBy(),$dto->getSortType()) // need to order by users.name
            ->paginate($dto->getPerPage());
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.