<p><code>SELECT u.username AS user, u.referrer AS ref, g.referrer AS gref FROM user u, user g WHERE u.referrer = g.username</code> </p>
<table>
<thead>
<tr>
<td>Username</td><td>Referrer</td></tr>
</thead>
<tbody>
<tr>
<td>James</td><td>John</td></tr>
<tr>
<td>Peter</td><td>John</td></tr>
<tr>
<td>John</td><td>Sarah</td></tr>
<tr>
<td>Matt</td><td>Sarah</td></tr>
<tr>
<td>Sarah</td><td>John</td></tr>
<tr>
<td>Bill</td><td>James</td></tr>
<tr>
<td>Patric</td><td>Frank</td></tr>
</tbody>
</table>


`SELECT u.username AS user, u.referrer AS ref, g.referrer AS gref FROM user u, user g WHERE u.referrer = g.username` 

| Username  |  Referrer   |
| -------- | -------- |
| James     |  John       |
| Peter     |  John       |
| John      |  Sarah      |
| Matt      |  Sarah      |
| Sarah     |  John       |
| Bill      |  James      |
| Patric    |  Frank      |


Post hidden from Hashnode

How can I write self join in Laravel?

Product

Explore

Company

Blogs

Support

Username	Referrer
James	John
Peter	John
John	Sarah
Matt	Sarah
Sarah	John
Bill	James
Patric	Frank