This is a Laravel Eloquent scope query which will return all models that have relationship with all of the IDs supplied

Eloquent Relationship Query Trait

<?php

namespace App;

trait QueryRelationships
{
    public function scopeWhereHasRelationIds($query, $relationName, array $relationIdList)
    {
        $query->whereHas($relationName, function ($query) use ($relationIdList) {
            $query->whereIn('id', $relationIdList)
                ->havingRaw('COUNT(id) = ?', [count($relationIdList)]);
        });
    }
}