Résultat qui sortent en double voir en triple

SELECT DISTINCT users.username, contrat.*, contrat.id AS idrow, CONCAT(contrat.annee_contrat, '-', contrat.id_gt, '-') AS numcc, type_contrat.* FROM contrat 
						INNER JOIN type_contrat ON contrat.id_type = type_contrat.id 
						INNER JOIN rcaisse ON contrat.id_rayon = rcaisse.id 
						INNER JOIN users_rcomptable ON rcaisse.id_rcompt = users_rcomptable.id_rcomptable 
						INNER JOIN users ON users_rcomptable.id_users = users.id  WHERE contrat.id_rayon IN (SELECT DISTINCT rcaisse.id FROM rcaisse 
								INNER JOIN users_rcomptable ON rcaisse.id_rcompt = users_rcomptable.id_rcomptable 
								INNER JOIN users ON users_rcomptable.id_users = users.id  
								WHERE users.username = :username GROUP BY rcaisse.id, rcaisse.id_rcompt, users.username) AND contrat.actif = 'oui' GROUP BY idrow, contrat.num_contrat