Не могу сделать запрос к mysql, который посчитает количество записей

$query = "SELECT * FROM themes LEFT JOIN users ON themes.add_name = users.id LEFT JOIN section ON themes.section_id = section.id_section WHERE themes.section_id = '$_GET[item]'"; 
		$result = mysqli_query($link, $query) or die (mysqli_error($link)); 
		for ($data = []; $row = mysqli_fetch_assoc($result); $data[] = $row); 
		$content = ''; 
		foreach ($data as $elem) { 
			$id_theme = $elem['id_theme']; 
			$query1 = "SELECT COUNT(*) as count FROM answers LEFT JOIN themes ON answers.id_themes =    themes.id_theme WHERE answers.id_themes = themes.id_theme GROUP BY id_themes"; 
			$result1 = mysqli_query($link, $query1) or die (mysqli_error($link)); 
			for ($data1 = []; $row = mysqli_fetch_assoc($result1); $data1[] = $row); 
				foreach ($data1 as $elem1) { 
					$count = $elem1['count']; 
				} 
			var_dump($data1); 
 
			$content .= "<li class=\"rows_item\">"; 
				$content .= "<div class=\"rows_main_item_wrap\">"; 
				$content .=  "<div class=\"rows_main_item_left\"> 
									<a href=\"?theme=$id_theme\">$elem[head]</a> 
									<p>$elem[name]</p> 
							   </div>"; 
				$content .=     "<div class=\"rows_main_item_top\"> 
										<p><span>Ответов: $count</span></p> 
								</div>"; 
				$content .= 	"<div class=\"rows_main_item_right\"> 
										<p> <a class=\"message\" href=\"\"> $elem[message]</a> </p> 
										<p> от $elem[name] </p> 
								</div>"; 
				$content .= "</div>"; 
 
			$content .= "</li>"; 
		}