I am using the below SQL query to grab licensed LFDS accounts and return their id, name, license type, identity provider, display name, and email address. I would also like to add what groups they are a member of in LFDS. Does anyone know what tables to look in for those? I looked at the ones I thought but

SELECT        do.id, do.name, 
                         (CASE ul.type WHEN '9bba0d89-9a13-455f-ada9-83cf071d46b9' THEN 'Full' WHEN '6e858768-cd5c-4e50-8fbe-aced7f67e25f' THEN 'Retrieval' WHEN 'dde75261-70e3-49f5-84bc-d8ef36f1aa56' THEN 'Participant' WHEN '57bf6faf-9269-1c97-4370-ab3d6984d2c5'
                          THEN 'Participant' END) AS LicenseType, idP.name AS IdentityProvider, (CASE WHEN ac.claim_id = '12' THEN str_val END) AS DisplayName, ac2.EmailAddress
FROM            LFDS.dbo.directory_objects AS do INNER JOIN
                         LFDS.dbo.identity_providers AS idP ON do.provider_id = idP.id INNER JOIN
                         LFDS.dbo.user_licenses AS ul ON do.sid = ul.sid INNER JOIN
                         LFDS.dbo.additional_claims AS ac ON do.sid = ac.sid INNER JOIN
                             (SELECT        sid, claim_id, str_val AS EmailAddress
                               FROM            LFDS.dbo.additional_claims
                               WHERE        (claim_id = 1)) AS ac2 ON do.sid = ac2.sid
WHERE        (ac.claim_id = '12')

couldn't find the groups. The group_membership table and it has the group_sid and member_sid associations, but I can't find the groups.