app\Providers\DBMacrosProvider.php

<?php

declare(strict_types=1);

namespace App\Providers;

use Illuminate\Support\ServiceProvider;

class DbMacrosProvider extends ServiceProvider
{
    public function boot(): void
    {
        collect(glob(database_path('macros/*/*.php'), GLOB_NOSORT))
            ->each(fn ($path) => require_once $path);
    }
}

I use this provider to autoload macros from single php files that live in database/macros/ folder