Поддержка JoomFish в собственном модуле - JoomFish

$db = new ps_DB;
$query="SELECT a.`category_parent_id`, b.`category_id` AS 'id', b.`category_name` AS 'name' 
FROM `#__{vm}_category_xref` a
LEFT JOIN `#__{vm}_category` b ON b.`category_id`=a.`category_child_id`
WHERE b.`category_publish`='Y'
ORDER BY `category_parent_id` ASC,b.`list_order` ASC, b.`category_name` ASC";
$db->setQuery($query);
$db->query();

while($db->next_record()){
	$category_parent_id = $db->f("category_parent_id");
	$id = $db->f("category_id");
	if(!isset($xref[$category_parent_id])){
		$xref[$category_parent_id] = array();
	}
	$xref[$category_parent_id][] = $id;
	$cats[$id] = $db->f("name");
}

SELECT a.`category_child_id`, b.`category_id`, a.`category_parent_id`, b.`category_name` AS 'name' 
FROM `#__{vm}_category` AS b
LEFT JOIN `#__{vm}_category_xref` AS a ON b.`category_id`=a.`category_child_id`
WHERE b.`category_publish`='Y'
ORDER BY `category_parent_id` ASC,b.`list_order` ASC, b.`category_name` ASC