title: Join query in Laravel 5.6
body: <p>I have a <code>Join</code> query like below in Laravel 5.6.</p>
  
  <pre><code>-&gt;join('employee', function ($join) {
                  $join-&gt;on('company.surah_id', '=', 'employee.surah_id');
                  $join-&gt;on('company.verse_id', '=', 'employee.ayah_id');
              })
  </code></pre>
  
  <p>I have a field <code>text</code> in <code>employee</code> table. I would like to fetch certain amount of character. More over I would like to fetch like below</p>
  
  <pre><code>"employee": {
       "text": "Jamal"
  } 
  </code></pre>