Unfortunately when you join a table using Eloquent
join methods (inner, outer, left etc), it doesn't check soft delete trait used in model and join all rows also deleted_at
columns that ARE NOT null
.
With this package and using it in your models, it will check deleted_at rows.
composer require blackplatinum/laravel-softdelete-fixer
Add this line to your models
Use SoftDeletesFix;
Add this key to your .env
file with namespace of you model classes
MODEL_NAMESPACE=App