Laravel Eloquent query OR problem

It could be like this

$tasks = Task::where('company_id', $company_id)->where('created_by',$user_id)->orWhere(function ($query) use ($task_ids) {
    $query->where('deleted_at', null)->whereIn('id', $task_ids);
})->get();

@michaloravec : I want OR condition.

Example: select records which is created by me OR i am involved in that.

whole query is like this

        $tasks = Task::where('deleted_at', null)->where('company_id',$request->input('company_id'));
        $tasks = $tasks->where('created_by',$request->input('user_id'));
        $task_ids = TaskUser::where('user_id',$request->input('user_id'))->pluck('task_id')->all();
        $tasks = $tasks->orWhereIn('id',$task_ids);

@engrlaravel I updated post.

$tasks = Task::where(function ($query) use ($company_id, $user_id) {
    $query->where('company_id', $company_id)->where('created_by', $user_id);
})->orWhere(function ($query) use ($task_ids) {
    $query->where('deleted_at', null)->whereIn('id', $task_ids);
})->get();

@michaloravec : Now it will show deleted records for created_by by me. because deleted_at condition applied only on

id IN(...)

@engrlaravel So add it where you need it.

$tasks = Task::where(function ($query) use ($company_id, $user_id) {
    $query->where('company_id', $company_id)->where('created_by', $user_id)->where('deleted_at', null);
})->orWhere(function ($query) use ($task_ids) {
    $query->where('deleted_at', null)->whereIn('id', $task_ids);
})->get();

@All: Is there any other better solution?

@engrlaravel This also should work

$tasks = Task::where('company_id', $company_id)->where('deleted_at', null)->where(function ($query) use ($user_id, $task_ids) {
    $query->where('created_by', $user_id)->orWhereIn('id', $task_ids);
})->get();

@all : Unfortunately this is not working, I am expecting a proper optimized query for laravel experts.

I want to apply all conditions on $task_ids as well

It's just pure logic, so you have to thinking more, otherwise you can pay to someone for it.

Result of this

$tasks = Task::where('deleted_at', null)->where(function ($query) use ($company_id, $user_id, $task_ids) {
    $query->where(function ($query) use ($company_id, $task_ids) {
        $query->where('company_id', $company_id)->where('created_by', $user_id);
    })->orWhereIn('id', $task_ids);
})->get();

Should be same like this

$tasks = Task::where(function ($query) use ($company_id, $user_id) {
    $query->where('company_id', $company_id)->where('created_by', $user_id)->where('deleted_at', null);
})->orWhere(function ($query) use ($task_ids) {
    $query->where('deleted_at', null)->whereIn('id', $task_ids);
})->get();

So there is no better solution.