title: Mysql left join with concatination?
body: <p>I have two tables which look like this </p>
  
  <pre><code>contacts
  -------------------------------------------------------
  | id | fname | lname | email | address | uid | uniqid |
  -------------------------------------------------------
  </code></pre>
  
  <pre><code>numbers
  ---------------------
  | id | pnumber | cid |
  ---------------------
  </code></pre>
  
  <p>This is my Sql Code</p>
  
  <pre><code>SELECT * FROM contacts LEFT JOIN numbers ON contacts.uniqid = numbers.cid 
  </code></pre>
  
  <p>The uniqid is the same as cid, my problem is when i am trying to left join these two tables it returns this
  <a href="https://i.stack.imgur.com/w973F.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/w973F.png" alt="&quot;"></a>
  Note: Sorry had to use an image because when i try to use text it breaks</p>
  
  <p>I want to get all the pnumbers in a single column without repeating. Is there any way to achieve this or should i use php?</p>
  
  <p><strong>Expected results</strong></p>
  
  <pre><code>id, fname, lname, email, address, uid, uniqid, id, pnumber,pnumber,pnumber, cid
  </code></pre>