MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


@@version


8.0.27


create table DemoTable
     (
     Name varchar(20),
     Fruit varchar(20)
     );
     insert into DemoTable values('Jon','Apple');
     insert into DemoTable values('Jon','Orange');
     insert into DemoTable values('Jon','Grape');
     insert into DemoTable values('Mike','Apple');
     insert into DemoTable values('Mike','Orange');

select name, group_concat(concat(rn,')', fruit) SEPARATOR '\n') from 
(select *,row_number() over (partition by name ) as rn from DemoTable) a  group by name



name
group_concat(concat(rn,')', fruit) SEPARATOR '\n')


Jon
1)Apple
2)Orange
3)Grape

Mike
1)Apple
2)Orange