How to get a model that has a model that has foo like bar?

Question

Laravel

Hello.
Need to find a device that has an attribute that has foo like "bar"
Example in SQL:
device n:m attribute

select device.id from device where device.id in 
   (select device_id from device_attribute where attribute_id in  
      (select attribute.id from attribute where attribute.foo like "bar")
   )

Tell me how to do it the smart way? I could look for attribute first, and then get device.

$attr = Attribute::where('foo', 'like', 'bar')->first();
$device = $attr->device()->first();

But it reverses the logic.
Thanks in advance

Answer 1

$devices = Device::whereHas('attributes', function ($query) {
    $query->where('foo', 'like', 'bar');
})->get();