Spatie role plugin for Laravel + seed users with roles, no roles assigned

Question

In Laravel 9 I tried adding a role to the user

Spatie just processed everything without errors, but in the database the relationship between role and user does not appear in the model for table "model_has_role"

I created a similar character

$roleName = 'MyRole';
$guardName = 'myGuard';

$roleObj = Role::create(['guard_name' => $guardName, 'name' => $roleName]);

Then create a user, for example

$user = new User($userDatas);

I collected all the data from the model that should be filled in

$arrayWithUsersData = [];

foreach($users as $user)
{
   if($users !== NULL)
   {
      $arrayWithUsersData[] = $user->getAttributes();
   }
}

After this, I tried to insert all users into the database at once, so I used

DB::table('users')->insert($arrayWithUsersData);

Finally I tried any possible way to assign roles in foreach $users Like:

$user->assignRole($roleName);
$user->assignRole($roleName, $guardName);
$user->assignRole([$roleName, $guardName]);
$user->assignRole($myRole);
$user->assignRole($myRole, $guardName);
$user->assignRole([$myRole, $guardName]);
$user->syncRoles($myRole);
$user->syncRoles($myRole, $guardName);
$user->syncRoles([$myRole, $guardName]);

But no error is given but still no relationship is created

Answer 1

The problem is that the spatie in allocateRole and syncRole works if the model exists

I mean Laravel model has "exists" attribute

vendor\spatie\laravel-permission\src\Traits\HasRoles.php contains some code from the allocateRole function

• syncRoles is a wrapper for allocateRole

  $model = $this->getModel();
  
    if ($model->exists) {
        $this->roles()->sync($roles, false);
        $model->load('roles');
    } else {
        $class = \get_class($model);
  
        $class::saved(
            function ($object) use ($roles, $model) {
                if ($model->getKey() != $object->getKey()) {
                    return;
                }
                $model->roles()->sync($roles, false);
                $model->load('roles');
            }
        );
    }

Therefore DB::table('users')->insert($arrayWithUsersData); Do not change the parameter "exists" in the model as it applies to the original data

So I had to switch to creating users one by one and saving them

$user = new User($userData);
$user->save();

Now Spatie creates the proper relationship.