Permission to ask friends, I made a table like this =

Table adjustment = ‘id’,’adjustment_number’, ‘status’.

Then the adjustment table has a relationship which I named materialloc, then another relationship to sbin.

Then I created a query program like this using Laravel 10

$query = Adjustment::with('materialloc.sbin');
         
if ($request->has('search') && $request->input('search')) {
    $searchTerm = $request->input('search');
    $query->whereHas('materialloc.sbin', function ($query) use ($searchTerm) {
        $query->where('name', 'like', '%' . $searchTerm . '%');
    });
    $query->orWhere('adjustment_number', 'like', '%' . $searchTerm . '%');
}

Why search using adjustment_number doesn’t work ?

But when I search by name in materialloc.sbin it works, is there something wrong with my use of whereHas, where or orWhere?

Please help friends