information_schema.GROUPS_ROLES

This table contains information about groups and the roles that are part of them. If you (the current user) has the GRANT permission, you can see all role-group pairs in this table. Otherwise, you will see only the pairs from groups you are part of.