Вывод из таблиц - Общие вопросы веб разработки

$query = $db->getQuery(true);
$query->select('n.id, n.name')
	->from('#__portfolio_works_names AS n')
	->leftJoin('#__portfolio_works_files AS f ON f.nid = n.id')
	->where("n.user_id = {$userid}");
$list = $db->setQuery($query)->loadObjectList();

foreach($list as $work) 
{
	?
}

$names = array_unique(array_column($list,'name'));
foreach($names as $name)
{
   echo $name.'<hr />';
   $keys = array_keys($list,$name);
   foreach ($keys as $key)
   {
       $file= $list[$key];
       echo $file->file.'<br />';
   }
}

foreach($list as $work) 
{
	$t = $work->title;
	$f = "<td>".$work->file_name."</td><td>".$work->descr."</td>";

	
	$out = "<table><tr><td colspan='2'>{$t}</td></tr><tr>{$f}</tr></table><br />";
	echo $out;
	
}

$query = $db->getQuery(true);
$query->select('n.id, n.title, f.file_name, f.descr')
	->from('#__portfolio_works_names AS n')
	->leftJoin('#__portfolio_works_files AS f ON f.nid = n.id')
	->where("n.user_id = {$userid}");
$list = $db->setQuery($query)->loadObjectList();

$titles = array_unique(array_column($list,'title'));
foreach($titles as $title)
{
   echo $title.'<hr />';
   $keys = array_keys($list,$title);
   foreach ($keys as $key)
   {
       $file= $list[$key];
       echo $file->file_name.'<br />';
   }
}	

foreach ($list as $work)
  titles[] = $work->name;
$titles = array_unique(titles);

foreach ($list as $work)
  $titles[] = $work->name;
$titles = array_unique($titles);
foreach($titles as $title)
{
   echo $title.'<hr />';
  
   $keys = array_keys($list,$title);
   foreach ($keys as $key)
   {
       $file= $list[$key];
       echo $file->file_name.'<br />';
   }
}

foreach ($list as $work){
	echo $work->name;
	$files = array_filter($list,
		function($el) use ($work->id) {
			return (int)$el->nid === (int)$work->id;
		}
	);
	if($files)
		foreach($files as $file)
			echo $file->file_name;
}