Prometheus - join series based on the key part of a label
label_values(kube_node_role, role)

sum(kube_pod_container_resource_requests_cpu_cores
  * on (node) group_left (role) kube_node_role{role="$node_role"})


kube_node_role out of kube-state-metrics can give you a relationship to join