Seems a silly question, but can't for the life of me get this working =(
The following SQL query works and is what I'm trying to replicate nicely with hasOne / belongsTo (assuming these are correct)?
$users = \DB::table('table1') ->join('table2', 'table1.userid', '=', 'table2.userid') ->where('table1.groupid', '=', 2) ->get(); return $users;
There's only ever a single row for 'userid' in both table1 and table2 (hence I thought hasOne()), but alas, I'm stumped!
Any help greatly appreciated! =)