I have the following SQL code that draws information from three tables: Users, Cohorts and Cohort Members
JOIN prefix_cohort ON prefix_cohort_members.cohortid = prefix_cohort.id
JOIN prefix_user ON prefix_cohort_members.userid = prefix_user.id
However, a single member can belong to several Cohorts according to "Cohort Members" table. Therefore the result duplicates each member the amount of times it repeats on a group.
How could I display only one unique User per row, but showing One group it belongs to, according to a word that Group name contains?