Getting Descendant of Ancestor with Descendant in a single query

[soundar8562]

Hello,
Here you can see my ancestor and descendant table,
Ancestor | Descendant
Electronics | Computer
Electronics | Laptop
Electronics | Mobile phone

Here is my code,
$page = Page::find(1);
$descendants = $page->getDescendants();
$descendants = $page->getDescendantsWhere('real_depth', '=', 1);
foreach ($descendants as $value) {
$ancestor=$page->getAncestors();
echo $ancestor[0]->name
echo $value->name;
}
}

Question:
As of right now, this works fine, but there will be a lot of queries if I handle some large amount of data, so is there any way to get the descendant of the ancestor with a descendant from a single query?

Thanks

[soundar8562]

Anyone here?

[abda11ah]

You need a breadcrumb ?