title: Comma separated column values in a laravel join query
body: <p>I have a laravel webapp in which my database is structured via the below tables. The relationship is that <code>transactions hasmany loading_hire_agreements via lhas_transactions</code>. </p>
  
  <pre><code>Table name: transactions 
  | id | date              | number |
  |----|-------------------|--------|
  | 1  | 12:00:00 00:00:00 | TRN#1  |
  | 2  | 10:00:00 00:00:00 | TRN#2  |
  
  Table name: loading_hire_agreements
  | id | number |
  |----|--------|
  | 1  | JY1001 |
  | 2  | JY1002 |
  | 3  | JY1003 |
  
  Table name: lhas_transactions
  | transction_id | lha_id |
  |---------------|--------|
  | 1             | 1      |
  | 1             | 2      |
  | 2             | 3      |
  </code></pre>
  
  <p>I want to write a join statement using laravel's <code>DB:table()-&gt;join(\* any relevant join *\)</code> so that the below output is generated.</p>
  
  <pre><code>| transactions.id  | transactions.number | loading_hire_agreements.number |
  |------------------|---------------------|--------------------------------|
  | 1                | TRN#1               | JY1001, JY1002                 |
  | 2                | TRN#2               | JY1003                         |
  </code></pre>
  
  <p>I "have" to use <code>DB:table()</code> because I am connecting this query to a front-end datatable service. </p>