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