SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id_users' in where clause is ambiguous

[kahfieidn]

Hi
I am getting following exception on filtering.

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id_users' in where clause is ambiguous

select count(*) as aggregate from 'lapor_izins' left join 'izins' on 'lapor_izins'.'id_izins' = 'izins'.'id' where 'id_users' = 6

if I comment following column, then filter works perfectly

Column::make("Jenis Izin", "izins.nama_izin")->sortable(),

======
Here is my builder

public function builder(): Builder { return LaporIzin::query() ->where('id_users', auth()->user()->id) ->with(['izins']); }

Please help, thanks

[kahfieidn]

Ive been solve, because 2 both table using the name fields id_users,