How to make optimal query with laravel ORM?

Question

ORM

there are three tables: products and options and product_options

In products fields:

• id
  
• name
  
• picture_id
  

In options fields:

• id
  
• name
  

In product_options fields:

• id
  
• product_id
  
• option_id
  

It is necessary to write such a query so that a filter is made on the products table , but the option_id fields of the associated product_options table

with Join are taken into account. :class)

Answer 1

https://laravel.com/docs/7.x/eloquent-relationship...