I have a stored prodedure for returning just a few properties of cats and a few properties of its kittens given an owner name

select {cat.name}, {cat.kittens.*} from Cat cat, Owner owner where cat.owner = owner.name

cat has properties: name, breed, collection of kittens, owner,
kitten is a cat
owner has properties: name and address

I am not sure how to go about mapping such a thing or how it would work and what it would return. I like any help as I am having a hard time wrapping my head around or mapping.
I would very much appreciate examples
thanks
aj