how to get rid of repeating row label in mysql result set

[Waseem Asghar]

I have two tables named customers with primary key cid and installment with foreign key cid. i join both table. Result set contains repeating items labels.But i want result set do not contain repeating items labels. explanation as under
custom table
cid name cell
12 Ramzan 033333
15 zahid 034444
21 Shahid 035222

installment table

cid amount date
12 1500 12-05-19
15 1500 13-05-19
12 1500 15-05-19
15 1500 17-05-19
21 2000 20-05-19

Resultant table

cid name cell date amount
12 Ramzan 03333 12-5-19 1500
12 Ramzan 03333 15-05-19 1500
15 Zahid 03444 13-05-19 1500
15 Zahid 03444 17-05-19 1500
21 Shahid 035222 20-05-19 2000


But i want to get this resultant Table

cid name cell date amount
12 Ramzan 03333 12-5-19 1500
15-05-19 1500
15 Zahid 03444 13-05-19 1500
17-05-19 1500
21 Shahid 035222 20-05-19 2000
total 8000

But i want to get this resultant Table

cid name cell date amount
12 Ramzan 03333 12-5-19 1500
15-05-19 1500
15 Zahid 03444 13-05-19 1500
17-05-19 1500
21 Shahid 035222 20-05-19 2000
total 8000