title: Soft delete in laravel is not hiding record in view
body: <p>I am using Eloquent soft delete to delete a row in the database. I use function destroy, in database column <code>deleted_at</code> have a date, but this is not hiding deleted records in view.
  My code in controller.</p>
  <pre><code>$query = Role::join('users', 'roles.id', '=','users.role_id');
  $user = User::all();
  $users = $query-&gt;select('users.*','roles.name as role_name')-&gt;paginate(10);
  </code></pre>
  <p>My code in User Model</p>
  <pre><code>use SoftDeletes;
  use HasFactory;
  
  protected $table = 'users';
  protected $guarded = [];
  protected $hidden = [
      'password', 'remember_token', 'deleted_at'
  ];
  
  public function roles() {
      return $this-&gt;belongsTo(Role::class);
  }
  </code></pre>
  <p>My code in Models Role</p>
  <pre><code>use HasFactory;
  
  protected $table = 'roles';
  protected $guarded = [];
  
  public function users() {
      return $this-&gt;hasMany(User::class);
  }
  </code></pre>