Laravel: Generate unique slug

app\Models\Blog.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Blog extends Model
{
    use HasFactory;

    protected $guarded = [];

    public static function boot()
    {
        parent::boot();

        static::creating(function ($post) {
            $post->slug = static::generateUniqueSlug($post->title);
        });
    }

    protected static function generateUniqueSlug(string $title): string
    {
        $slug = str_slug($title);

        if (static::query()->where('slug', $slug)->doesntExist()) {
            return $slug;
        }

        $last = static::query()
            ->selectRaw('CAST(REPLACE(`slug`, ?, "") AS UNSIGNED) `last`', [$slug . '-'])
            ->whereRaw('REPLACE(`slug`, ?, "") REGEXP "\-[0-9]+$"', [$slug])
            ->orderBy('last', 'DESC')
            ->value('last');

        return $slug . '-' . ($last + 1);
    }
}