MySQL – Group by one value and concat other values in one column

I have a database with email and phone columns. One email can have several phones, which results in multiple rows with same email but different phone numbers.
I want to query all emails with it's phones grouped in one single column.
Example
Convert from this

To this

Thanks!


View on Stack Overflow