Wrong cardinality is inferred

CREATE TABLE public.users (
  id uuid NOT NULL,
  updated_at timestamptz NOT NULL DEFAULT now(),
  updated_by_id uuid NOT NULL,
  first_name text NULL,
  CONSTRAINT users_pkey PRIMARY KEY (id),
  CONSTRAINT users_un UNIQUE (id)
);

CREATE TABLE public.users_roles (
  user_id uuid NOT NULL,
  updated_at timestamptz NOT NULL DEFAULT now(),
  "role" public."user_role" NOT NULL DEFAULT
  updated_by_id uuid NOT NULL DEFAULT default_uid(),
  CONSTRAINT users_roles_pkey PRIMARY KEY (user_id),
  CONSTRAINT users_roles_un UNIQUE (user_id),
  CONSTRAINT users_roles_updated_by_id_fkey FOREIGN KEY (updated_by_id) REFERENCES public.users(id),
  CONSTRAINT users_roles_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE ON UPDATE CASCADE
);

const profileRes = await db
  .from('users')
  .select(
    `
      *,
      role:users_roles!users_roles_user_id_fkey(
        *
      )
    `
  )
  .eq('id', session.user.id)
  .single();