Laravel. How to search in many to many relationship?

Question

Laravel

There is a list of books. Each book is associated with an author and a store. Each book can have multiple authors or stores, so many to many relationships are used here. There is a form with checkboxes: with authors, stores and books. When you click on these checkboxes, the corresponding books should be displayed. How to write a query so that a filter occurs simultaneously for both the author and the store. This can be done through whereHas, but how to do several whereHas at the same time and take into account that, for example, the author or store may not be selected.

Answer 1

$book = Book::select('id', 'name');
if ($author) {
  $book = $book->whereHas(...);
}

if ($shop) {
 $book = $book->whereHas(...);
}

$results = $book->get();

For example, yes. In whereHas, substitute the appropriate conditions for the selection.

Answer 2

Join