realodix/urlhub

use App\Models\Url;

class UserService
{
    //
    public function guestCount()
    {
        $url = Url::select('ip', DB::raw('count(*) as total'))
                    ->whereNull('user_id')->groupBy('ip')
                    ->get();

        return $url->count();
    }
}