How to generate a report from resource directory regarding resource organization and Business unit

Summary:

We are trying to get the report using below Query, but it is showing additional data for example for a user it is showing as 3 organizations assigned where in resource directory there is only one organization.

Query:
select hz.party_id,hz.party_name,hr.name ResDirecory_Organization,all_bu.bu_name
from
FUSION.JTF_RS_GROUP_MEMBERS ResOrgMember
inner join Fusion.hr_organization_v hr on hr.organization_id=ResOrgMember.group_id
inner join fusion.hz_parties hz on hz.party_id=ResOrgMember.resource_id
left join fusion.JTF_RS_RESOURCE_ORG_BU res_bu on res_bu.organization_id=ResOrgMember.group_id