Query: identity_group_user

with user_group_id as (
  select
    jsonb_array_elements(user_groups) ->> 'groupId' as g_id,
    name,
    id
  from
    oci_identity_user
)
select
  u.name "User Name",
  u.id as "User ID"
from
  oci_identity_group as g,
  user_group_id as u
where
  g.id = u.g_id
  and g.id = $1