Im trying to get an specified record from a join table, my query is as below

```
$user = Auth::user(); //current authenticated user
$user_id = $user->id; //get the current authenticated user's id
$users = DB::table('users') //join table users and table user_details base from matched id;
    ->join('user_details', 'users.id', '=', 'user_details.id')
    ->find($user->id) //find the record matched to the current authenticated user's id from the joint table records
    ->get(); //get the record
dd(var_dump($users)); //dump result

```

but unfortunately sadly it gives me this error

> 
> SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in where clause is ambiguous (SQL: select \* from `users` inner join `user_details` on `users`.`id` = `user_details`.`id` where `id` = 1 limit 1)
> 
> 
> 

so i bet my query is wrong LOL! anyway, any help, ideas please?