Query to find members of a role

L&G 691 P18 (Aveksa)

  I need to write a query to find members (both direct and indirect) of roles.  I can get the direct memebers from the view pv_user_role_membership but how to get  indirect memebers as well. What tables i need to join.  Any help is really appreciated.