sfp_api_laravel_serprati/app/Services/AssociateValidationService.php

<?php

namespace App\Services;

use App\Models\User;
use App\Support\Cpf;

class AssociateValidationService
{
    public function validate(array $data): ?User
    {
        $search = $data['search'] ?? null;
        $cpfSearch = Cpf::digits($search);

        return User::query()
            ->with([
                'dependents' => function ($query) {
                    $query->where('status', 'active');
                },
            ])
            ->where(function ($query) use ($data, $search, $cpfSearch) {
                if (!empty($search)) {
                    $query->where(function ($query) use ($search, $cpfSearch) {
                        $query->where('registration', $search)
                            ->orWhere('name', $search);

                        if ($cpfSearch) {
                            $query->orWhere('cpf', $cpfSearch);
                        }
                    });
                }
            })
            ->where('status', 'active')
            ->where('type', 'associado')
            ->first();
    }
}