title: How to find all objects of type Item with thier parent type Family
body: <p>Here is my Objects table -</p>
  
  <p><a href="https://i.stack.imgur.com/7u7Is.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7u7Is.png" alt="enter image description here"></a></p>
  
  <p>I am trying to write a query that can fetch all objects of type C with their parent of type A. So the query should return like </p>
  
  <p><a href="https://i.stack.imgur.com/dplZf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dplZf.png" alt="enter image description here"></a></p>
  
  <p>I am trying to do it using recursion but not getting the desired result. Any help would be appreciated.  Thank you.</p>