How to use a sub_query with a table that has soft delete?

I have a query and a subquery that looks like this:

// $query not included here
$query = $query->getQuery();
$subQuery = User::select('*')
    ->fromSub($query, 'sub_query')
    ->where($status, 'LIKE', '%' . $statusValue . '%')
    ->with($this->eagerLoadedRelationships)
    ->get();

But I get the following error: Column not found: 1054 Unknown column 'users.deleted_at' in 'where clause'. When I remove use SoftDeletes; in my User model, it works fine. But I need that soft delete.

I tried User::withoutTrashed()->select('*')... but it's the same.

Is there a way for me to go around this?

I can't list the columns inside select. And I kinda have to use this sub query to check the results of the previous query (I can't add where() to the previous query).

Try following

$subQuery = User::select('*')
    ->fromSub($query, 'sub_query')
    ->where($status, 'LIKE', '%' . $statusValue . '%')
    ->whereNull('deleted_at')
    ->with($this->eagerLoadedRelationships)
    ->get();

$query = $query->getQuery();

// Use "toBase()" to remove the global scopes from the subquery, including soft delete scope
$subQuery = User::select('*')
    ->fromSub($query->toBase(), 'sub_query')
    ->where($status, 'LIKE', '%' . $statusValue . '%')
    ->with($this->eagerLoadedRelationships)
    ->get();

By calling toBase() on the subquery, you are essentially getting the underlying Query Builder instance without any global scopes applied, including the soft delete scope. This should allow you to run the subquery without encountering the "Column not found" error related to deleted_at.