get all softdeletes laravel

        $tables = collect(Schema::getAllTables())->pluck('Tables_in_pmp');

        $softdeletes = [];


        foreach ($tables as $table) {
            if (Schema::hasColumn($table, 'deleted_at')) {
                $softdeletes[$table] = DB::table($table)->whereNotNull('deleted_at')->count();
            }
        }

        $softdeletes = collect($softdeletes)->filter(function ($value, $key) {
            return $value > 0;
        });

        dd($softdeletes);