SOQL in Salesforce supports "relationship queries" that works on both directions, viz, parent-to-child and child-to-parent.

https://developer.salesforce.com/docs/atlas.en-us.soql_sosl....