<p>Basically the question is how to get from this:</p>

<pre>
foo_id   foo_name
1        A
1        B
2        C
</pre>

<p>to this:</p>

<pre>
foo_id   foo_name
1        A B
2        C
</pre>

```
```
SELECT id, GROUP_CONCAT(name SEPARATOR ' ') FROM table GROUP BY id;
```
```
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html#function_group-concat
From the link above,
```
GROUP_CONCAT
```
: This function returns a string result with the concatenated non-NULL values from a group. It returns NULL if there are no non-NULL values.