Finds the depth of an item's children relative to its depth.
For example, if the item has a depth of 2, and the maximum of any child in the menu link tree is 5, the relative depth is 3.
$item: An array representing a menu link item.
The relative depth, or zero.
function menu_link_children_relative_depth($item) {
$query = db_select('menu_links');
$query
->addField('menu_links', 'depth');
$query
->condition('menu_name', $item['menu_name']);
$query
->orderBy('depth', 'DESC');
$query
->range(0, 1);
$i = 1;
$p = 'p1';
while ($i <= MENU_MAX_DEPTH && $item[$p]) {
$query
->condition($p, $item[$p]);
$p = 'p' . ++$i;
}
$max_depth = $query
->execute()
->fetchField();
return $max_depth > $item['depth'] ? $max_depth - $item['depth'] : 0;
}