title: mysql - group, but show all row of a column
body: <p>I want to group fields but want to show all row of a column called <code>remain</code>:</p>
  
  <p><strong>here is current output without grouping:</strong></p>
  
  <p><img src="https://i.stack.imgur.com/yCJMI.png" alt="enter image description here"></p>
  
  <p><strong>And output with group:</strong></p>
  
  <p><img src="https://i.stack.imgur.com/pKozD.png" alt="enter image description here"></p>
  
  <p><strong>And I want This when I group:</strong></p>
  
  <p><img src="https://i.stack.imgur.com/KDSBb.png" alt="enter image description here"></p>
  
  <p><strong>Here is mysql query:</strong></p>
  
  <pre><code>SELECT staff.name,
    staff.designation_id_designation,
    staff.status_id_status,
    Concat_Ws('=', leave_remain.leave_type_id_leave_type, leave_remain.days) AS
    remain
  FROM staff INNER JOIN
    leave_remain ON staff.id_staff = leave_remain.staff_id_staff
  GROUP BY staff.name    
  </code></pre>