How to merge records for query set
You can get it by using group_concat()




create table t (notes varchar(200), id int, name varchar(100), emp_Id int);






insert into t values ('1. Finish Designing Queries', 10, 'John', 2);
insert into t values ('2. Finish Designing Queries', 10, 'Jack', 5);
insert into t values ('3. Other note', 20, 'Jack', 5);






select notes, id, group_concat(name, ':', emp_id)
from   t
group by id;



notes                       | id | group_concat(name, ':', emp_id)
:-------------------------- | -: | :------------------------------
1. Finish Designing Queries | 10 | John:2,Jack:5                  
3. Other note               | 20 | Jack:5                         



dbfiddle here