Eloquent query : Retrieve the list of offices where the user possess all the desks, not just one (nested whereHas)

Question

I want to retrieve all the offices ( with the desks eager loaded) but I only want offices where the user possess all the desks in the office

I have the following models and relationships between them :

I came up with the following query which seems to almost work :

<?php 

Office::query()
    ->whereHas('desks', function ($query) {
        $query->whereHas('possessedDesks', function ($query) {
            $query->where('user_id', auth()->id);
        });
    })
    ->with(['desks'])
    ->get();

The current query seems to return a result where if a user own a single desk in the office then the office is returned in the query. Am I missing something ? Is there a way to be more strict in the whereHas to have some kind of and instead of a or

Thanks in advance for your help ;)

Edit :

Thanks to Tim Lewis's comment I tried this with not more result :

<?php

Office::query()
    ->withCount('desks')
    ->whereHas('desks', function ($query) {
        $query
            ->whereHas('possessedDesks', function ($query) {
                $query->where('user_id', auth()->id);
            })
            ->has('possessedDesks', '=', 'desks_count');
    })
    ->with(['desks'])
    ->get();

Edit 2 :

I managed to get exactly what I need, outside of an Eloquent query. The problem is still persist since I need it to be in an Eloquent query because I need this for a query string request (Search engine).

<?php

$offices = Office::query()
    ->with(['desks'])
    ->get();

$possessedDeskIds = auth()->user->with('possessedDesks.desk')->possessedDesks()->get()->pluck('desk.id');

$fullyOwnedOffices = [];
foreach($offices as $office) {
    $officeDeskIds = $office->desks()->pluck('id');

    $atLeastOneDeskIsNotPossessed = false;
    foreach($officeDeskIds as $officeDesk) {
        if ($possessedDeskIds->doesntContain($officeDesk)) {
            $atLeastOneAromaIsNotPossessed = true;
            break;
        }
    }

    if (!$atLeastOneDeskIsNotPossessed) {
        $fullyOwnedOffices[] = $office;
    }
}

Edit 3 :

Ok, With the previous edit and the need to have some kind of one line query (for the query string of a search engine) I simplified the request since the nested whereHas where hard to make sense of.

It's not the prettiest way to do it, It add more query for the process, but with the code from the Edit2 I can generate an array of Ids of the Office where all the Desk are possessed by the user. With that I can just say that when this option is required in the search engine, I just select the ones my algorithm above gave me and no more logic in the query.

If some genius manage to find a way to optimize this query to add the logic back inside of it, I'll take it but for now it works as expected.

Thanks Tim for your help

<?php

class SearchEngineController extends Controller
{
    public function index(Request $request) {
        $officesWithAllDesksPossessed = collect([]);
        if ($request->has('with_possessed_desks') && $request->input('with_possessed_desks')) {
            $publicOffices = Office::query()
                ->isPublic()
                ->with(['desks'])
                ->get();

            $possessedDeskIds = currentUser()
                ->possessedDesks()
                ->with('desk')
                ->get()
                ->pluck('desk.id');

            foreach($publicOffices as $office) {
                $publicOfficesDeskIds = $office->desks()->pluck('id');

                $atLeastOneDeskIsNotPossessed = false;
                foreach($publicOfficesDeskIds as $officeDesk) {
                    if ($possessedDeskIds->doesntContain($officeDesk)) {
                        $atLeastOneDeskIsNotPossessed = true;
                        break;
                    }
                }

                if (!$atLeastOneDeskIsNotPossessed) {
                    $officesWithAllDesksPossessed->push($office);
                }
            }

            $officesWithAllDesksPossessed = $officesWithAllDesksPossessed->pluck('id');
        }


        return Inertia::render('Discover', [
            'offices'=> OfficeResource::collection(
                Office::query()
                    ->isPublic()
                    ->with(['desks'])
                    ->when($request->input('search'), function ($query, $search) {
                        $query->where('name', 'like', "%{$search}%");
                    })
                    ->when($request->input('with_possessed_desks'), function ($query, $active) use($officesWithAllDesksPossessed) {
                        if ($active === 'true') {
                            $query->whereIn('id', $officesWithAllDesksPossessed);
                        }
                    })
                    ->paginate(10)
                    ->withQueryString()
            ),
            'filters' => $request->only(['search', 'with_possessed_desks']),
        ]);
    }
}