Where Doesn't Have Relation

For this query I just ended up filtering the collection:

$products = Product::whereIn('id', $this->selected)
    ->with('records.parts')->get();

$this->products = $this->filterParts($products);

protected function filterParts(Collection $products): Collection
{
    $filtered = $products->filter(function ($product) {
        return $product->records->filter(function ($record) {
            return $record->whereDoesntHave('parts');
        });
    });

    return $filtered;
}

But for the next deeper nested relation I'll have to use something else.

I now have to filter another level down and check a column for null.

This one:

protected function filterFactories()
{
    $filtered = $this->products->filter(function ($product) {
        return $product->records->filter(function ($record) {
            return $record->materials->filter(function ($material) {
                return !is_null($material->factory_material_id);
            });
        });
    });

    $this->factories = $filtered;
}

Doesn't work.

There is a single material that does have a value in the factory_material_id column so $this->factories should have a single product, but I'm not quite there yet.

Well this works but it's disgusting :(

protected function filterFactories()
{
    $filtered = [];

    foreach ($this->products as $key => $product) {
        foreach ($product->records as $record) {
            foreach ($record->materials as $material) {
                if (!is_null($material->factory_material_id)) {
                    $filtered[] = $product;
                    $this->products->forget($key);
                }
            }
        }
    }

    $this->factories = collect($filtered);
}

Anyone with some mad collection skills that can assist in refactoring this I would be greatly appreciative.

Wouldn't this work?

$products = Product::whereIn('id', $this->selected)
  ->with(['records', function ($query) {
      $query->doesntHave('parts');
  }])->get();

$products = Product::with(['records' => function ($query) {
    $query->doesntHave('parts');
}])->whereIn('id', $this->selected)->doesntHave('records.parts')->get();