i have a query in mysql that return me repeated results i want results unique.e.g in my example i have company name it return me repeated name,id.

```
SELECT 
      company.name,
      company.id,
      branchInfo.name,
      branches.visible 
FROM branches  
INNER JOIN users branchInfo ON branches.branchId=branchInfo.id 
INNER JOIN users company ON branches.companyId=company.id   
WHERE branches.visible=1 

```

it returns me the multiple time repeated data so i want it unique.