Id name gp
Group 1 a1 1
2 a2, a3 2 group
3 a4, a5, a6 3 groups
4 a7 4 group
.

Now want to query results in the following

Id name gp
Group 1 a1 1
2 a2 2 group
2 a3 2 group
Group 3 a4 3
3 a5 3 group
3 the a6 3 groups
4 a7 4 group
.

Table name field in the test the value of the detected separately, thank you!