Simple SQL to Eloquent Query (Laravel) <p>I have two tables: users (Users) and groups (Groups).</p> <pre><code> Users ----------------- id | username | group 1 | Bob | 2 Groups ----------------- id | name 1 | firstgroup 2 | secondgroup </code></pre> <p>I would like to display: users.ID, users.username, group.name (1, Bob, secondgroup) An SQL statement like so would work:</p> <pre><code>SELECT Users.id, Users.username, Groups.name FROM Users INNER JOIN Groups ON Groups.id = Users.group </code></pre> <p>However, I'm struggling to write this in Eloquent, since there is no "FROM". At the moment I'm going for something along the lines of the below, using JOINS (<a href="http://laravel.com/docs/queries#joins" rel="nofollow">http://laravel.com/docs/queries#joins</a>)</p> <pre><code>$users = Users::select('id','username', 'Groups.name')-&gt;joins('Groups.id', '=', 'id')-&gt;get(); </code></pre> <p>Now this isn't working - I think the joins has to come before the select but I just can't work it out :(</p>