Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

devkon98's avatar

Eloquent orWhere Join query makes error

I have this query:

$hasBorrowedCars = CarBorrow::query()
            ->where('borrowed_from_user_id', $userId)
            ->orWhere(function ($query) use ($userId) {
                $query->join('car_owners', 'user_id', '=', 'car_owners.user_id')
                    ->where('car_owners.user_id'', $userId);
            })
            ->exists();

but makes me this error:

Unknown column 'user_id' in 'where clause' (SQL: select exists(select * from `car_borrows` where `borrowed_from_user_id` = 2 or (`user_id` = 2)) as `exists`)
0 likes
0 replies

Please or to participate in this conversation.