I worked according to this method in my project, and encountered a problem.

The following code though should have returned only a profile in the role of scribe or merchant They all came back in some of the searches.

    public function scopeFilter ( $query, array $filters)
    {
        $query->when($filters['s'] ?? false, function ($query, $search){
            $query
                ->where('first_name', 'LIKE', '%'.$search.'%')
                ->orWhere('last_name', 'LIKE', '%'.$search.'%');
        });

        $query->when($filters['roles'] ?? false, function ($query, $roles) {
           $query
               ->whereHas('roles', function ($query) use ($roles) {
                   $query->whereIn('slug', $roles);
               });
        });
    }

the result qury:

SELECT * FROM `profiles`
	WHERE `active` = '1'
	and (
		`first_name` LIKE '%{SEARCH_INPUT}%'
		or `last_name` LIKE '%{SEARCH_INPUT}%'
		and exists (
			SELECT * FROM `roles`
				inner join `profile_role` on `roles`.`id` = `profile_role`.`role_id`
				WHERE `profiles`.`id` = `profile_role`.`profile_id`
				and `slug` in ('scribe', 'merchant')
		)
	)

This is how it will work:

SELECT * FROM `profiles` 
	WHERE `active` = '1' 
	and (`first_name` LIKE '%{SEARCH_INPUT}%' or `last_name` LIKE '%{SEARCH_INPUT}%')
	and exists (
		SELECT * FROM `roles`
			inner join `profile_role` on `roles`.`id` = `profile_role`.`role_id`
			WHERE `profiles`.`id` = `profile_role`.`profile_id`
			and `slug` in ('scribe', 'merchant')
	)

How do I write the last query in laravel?

EDIT: Oops .. I just noticed that jefry talks about this in a lesson below

Search (The Cleaner Way)

Updated Series Available