Ответ

Misha v.3 23.03.2007 02:12 / 23.03.2007 02:13

$t[^table::sql{
	SELECT
		parents.parent_id,
		parents.parent_name,
		children.child
	FROM
		parents LEFT JOIN children ON (parents.parent_id = children.parent_id)
}]

$h[^t.hash[parent_id;$.distinct[tables]]]

^h.foreach[k;v]{$k	"$v.parent_name"	^v.menu{"$v.child"}[, ]}[^#0A]