How to sort books by first author in Elequent?

Question

Laravel

Hello. It is not possible to write a qlequent query to sort books by the first (first) author (one-to-many relationship - the book has many authors). I use WhereHas, but something doesn't work...

Answer 1

It seems to me the request will turn out to be too complicated.
It is better for you to add a column in the table of books where to write down the first author.