How to get all parents that children all match attribute?

I have this parent table

and this children table

I want to query the tables(using laravel elloquent) and get the parents that have all their children match status 3. For example here id = 2 in parent table matches this criteria

>Solution :

I’m unable to test it, but this may work:

Parent::whereDoesntHave('children', function($query) {
    $query->where('status', '!=', 3);
})->whereHas('children')

The resulting SQL looks like this:

select 
  * 
from 
  `parents` 
where 
  not exists (
    select 
      * 
    from 
      `children` 
    where 
      `parents`.`id` = `children`.`parent_id` 
      and `status` != 3
  ) 
  and exists (
    select 
      * 
    from 
      `children` 
    where 
      `parents`.`id` = `children`.`parent_id`
  )

It selects only parents that have children and excludes the ones that has children with a status not equal to 3