Yo lo haría con UNION. Así para 4 valores de p (para ejemplificar)
Código:
SELECT 1 AS P, Count(id) AS total FROM femenino WHERE p1='R1' Or p1='R2'
UNION
SELECT 2 AS P, Count(id) AS total FROM femenino WHERE p2='R1' Or p2='R2'
UNION
SELECT 3 AS P, Count(id) AS total FROM femenino WHERE p3='R1' Or p3='R2'
UNION
SELECT 4 AS P, Count(id) AS total FROM femenino WHERE p4='R1' Or p4='R2'
Te marco en rojo las variables... el FOR para realizarlo te lo dejo a vos
