Treeview - Produkte zur Kategorie

$query = "
SELECT
cat.`name_".$language."` AS catname,
cat.category_id AS category_id,
prod.`name_".$language."` AS prodname,
prod.product_id AS product_id
FROM
`#__jshopping_products` AS prod
INNER JOIN
`#__jshopping_products_to_categories` AS pr_cat
ON
pr_cat.product_id = prod.product_id
LEFT JOIN
`#__jshopping_categories` AS cat
ON
pr_cat.category_id = cat.category_id
WHERE
prod.product_publish = '1'
AND
cat.category_publish='1'
AND
pr_cat.product_id = prod.product_id
";
$db->setQuery($query);
$row = $db->loadObjectList();
foreach ($row as $value) {
print_r("Katname: ".$value->catname."<br>Produkte zur Kategorie: ".$value->prodname."<br><br>");
}

Katname: Wandbilder
Produkte: Acryl Schild
Katname: Dekoration
Produkte: Pappdisplay
Katname: Wandbilder
Produkte: Pappdisplay
Katname: Dekoration
Produkte: Foto-Tischläufer & Tischdecke
...​

Katname: Wandbilder Produkte: Acryl Schild, Pappdisplay, ...
Katname: Dekoration Produkte: Pappdisplay, Foto-Tischläufer & Tischdecke​, ...
....

$query = "
SELECT
cat.`name_".$language."` AS catname,
cat.category_id AS category_id
FROM
`#__jshopping_categories` AS cat

WHERE
cat.category_publish='1'

";
$db->setQuery($query);
$row = $db->loadObjectList();

foreach ($row as $value) {

print_r("<br><br>Katname: ".$value->catname."<br><br>\n");

$query = "
SELECT
prod.`name_".$language."` AS prodname,
prod.product_id AS product_id
FROM
`#__jshopping_products` AS prod
LEFT JOIN
`#__jshopping_products_to_categories` AS pr_cat
ON
pr_cat.product_id = prod.product_id
WHERE
prod.product_publish='1'
AND
pr_cat.category_id = ".$value->category_id."


";
$db->setQuery($query);
$row = $db->loadObjectList();

foreach ($row as $value) {

print_r("Produkte: ".$value->prodname."<br>\n");
}



}