AppServiceProvider.php

<?php

use Illuminate\Database\Eloquent\Builder;

protected function registerWhereLikeMacro()
    {
        Builder::macro('whereLike', function ($attributes, $searchTerm = null) {
            $this->where(function (Builder $query) use ($attributes, $searchTerm) {
                foreach (array_wrap($attributes) as $attribute) {
                    $query->when(
                        str_contains($attribute, '.'),
                        function (Builder $query) use ($attribute, $searchTerm) {
                            [$relationName, $relationAttribute] = explode('.', $attribute);
                            $query->orWhereHas($relationName, function (Builder $query) use ($relationAttribute, $searchTerm) {
                                $query->where($relationAttribute, 'LIKE', "%{$searchTerm}%");
                            });
                        },
                        function (Builder $query) use ($attribute, $searchTerm) {
                            $table = $query->getModel()->getTable();
                            $query->orWhere("{$table}.{$attribute}", 'LIKE', "%{$searchTerm}%");
                        }
                    );
                }
            });
            return $this;
        });
    }

Searchable.php

<?php

namespace App\Concerns;

trait Searchable
{
    public function scopeSearch($query, $search)
    {
        $query->whereLike($this->search, $search);
    }
}