smarty ile alta alta sorgu

$datas = $db->get_results("SELECT name_tr, id FROM menu order by well asc")
foreach($datas as data)
{
echo $data['name_tr'];
$dataid = $data['id'];
$altmenu = $db->get_row("SELECT name_tr,id FROM menu WHERE menuid = $dataid")
echo $altmenu['name_tr'];
}