Transitive relationships
Best approach for a Drupal based CiviCRM would be using Views which is a Drupal module, then you can build up search/displays that will daisy-chain the relationships the way you describe.