MySQL - цикл в цикле - как сделать проще - Модификации расширений для Joomla

$line

$row

$result = mysql_query("SELECT * FROM products") or die(mysql_error());
$data = array();    
while ($line = mysql_fetch_array($result)) {
$data[$line['id_parent']][] = $line;
}

foreach($data as $key => $items){
echo '<div>'.$key.'</div>';
echo '<table>';
foreach($itemsas as $item){
echo '<tr><td>'.$item['id'].'</td><td>'.$item['name'].'</td></tr>';
}
echo '</table>';
}

<div>1</div>
<table></table>
<div>2</div>
<table></table>

while ($line = mysql_fetch_array($result)) {
  if( !empty($line['id_parent']) ){
     $data[$line['id_parent']][] = $line;
  }
}

$data = array();
while ( $line = mysql_fetch_array( $result ) ) {
	if ( !empty( $line['id_parent'] ) ) {
		$data[$line['name_parent']][$line['name_second']][] = $line;
	}
}

foreach ( $data as $titleParent => $parents ) {
	echo '<div>' . $titleParent . '</div>';
	echo '<table>';
	foreach ( $parents as $titleChildren => $items ) {
		echo '<tr><td colspan="2">' . $titleChildren . '</td></tr>';
		foreach ( $items as $item ) {
			echo '<tr><td>' . $item['id'] . '</td><td>' . $item['name'] . '</td></tr>';
		}
	}
	echo '</table>';
}

=>

$result = mysql_query("SELECT * FROM products") or die(mysql_error());
$data = array();    
while ($line = mysql_fetch_array($result)) {
$data[$line['id_parent']][] = $line;
}
 
foreach($data as $key => $items){
echo '<div>'.$key.'</div>';
echo '<table>';
foreach($items as $item){
echo '<tr><td>'.$item['id'].'</td><td>'.$item['name'].'</td></tr>';
}
echo '</table>';
}

$data = array(id_parent_1=>array($item1_1,$item1_2,$item1_3...), id_parent_2=>array($item2_1,$item2_2,$item2_3...), ...)

$result = mysql_query("SELECT * FROM products") or die(mysql_error());
$data = array();
$names_by_id=array();
while ($line = mysql_fetch_array($result)) {
$data[$line['id_parent']][] = $line;
$names_by_id[$line['id']]=$line['name'];
}
 
foreach($data as $key => $items){
echo '<div>'.$key.'-'.$names_by_id[$key].'</div>';
echo '<table>';
foreach($items as $item){
echo '<tr><td>'.$item['id'].'</td><td>'.$item['name'].'</td></tr>';
}
echo '</table>';
}

$result = mysql_query("SELECT * FROM products") or die(mysql_error());
$data = array();
$names_by_id=array();
while ($line = mysql_fetch_array($result)) {
$data[$line['id_parent']][] = $line;
$names_by_id[$line['id_parent']]=$line['name_parent'];
}
 
foreach($data as $key => $items){
echo '<div>'.$key.'-'.$names_by_id[$key].'</div>';
echo '<table>';
foreach($items as $item){
echo '<tr><td>'.$item['id'].'</td><td>'.$item['name'].'</td></tr>';
}
echo '</table>';
}