Getting Comma Separated List Without Linked Table

Hi Experts,

This is a similar question to https://www.experts-exchange.com/questions/28688416/Getting-Records-as-comma-seperated-list.html , but without the linked table.

I have 2 tables

loc_types
id
name

locations
id
name
type_id

This is obviously a 1-to-many relationship (1 loc type, many locations)

I need to get a list of type names, and a comma-separated list of all locations that fall under that type.

Any help would be greatly appreciated.

By the way this is a MySQL database.