Hello i have a problem with a Sql script

SELECT col1_id, col1_name, col2 FROM table GROUP BY ?????

col1_id col1_name col2
A john bear
A john dog
A john cat
A john bear
A john dog
A john cat
A john dog
A john cat
A john bear
A john dog
A john cat
A john bear
A john dog
A john cat
A john dog
A john cat

I want to return all results. It has to return like this: echo col1_id . col1_name (A john) and then col2 (bear,dog, cat)

i don't want it to result echo col1_id . col1_name (A john,A john, Ajohn) and col2 (bear,dog, cat)

Altough it shows the results on inspector response it doen't print them Why? I want to show the results on GROUP__CONCAT

Hey, is the question still relevant?