title: Get all values from one-to-many relationship in one row
body: <p>I have a one-to-many relationship in my database. 
  <img src="https://i.stack.imgur.com/mQQlj.png" alt="enter image description here"></p>
  
  <p>I want to fetch all cities with all the cinemas appended in one row as CSV. I have tried:</p>
  
  <pre><code>SELECT city.*,CONCAT(cinema_name)
  FROM city
  LEFT JOIN cinema
  ON cinema.city_id=city.city_id
  GROUP BY city.city_id
  </code></pre>
  
  <p>But this only returns first cinema.</p>