PHP - Cargar Array desde Mysql

<table>

<?php

$sql="SELECT *, dato1, count(dato2)

FROM tabla1 AS t1, tabla2 AS t2 

WHERE t1.id=t2.dato1 

GROUP BY dato1 ORDER BY dato1 ASC LIMIT 10";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

	while($row = $result->fetch_assoc()) {

		echo "<tr><td>".$row["dato1"]."</td><td>".$row['count(dato2)']."</td></tr>";

					}

				echo "</table>";

					}

				else {

				echo "0 results";

						}

	?>

$sql="SELECT *, count(dato2), count(dato3)

FROM tabla1 AS t1, tabla2 AS t2, tabla3 AS t3 

WHERE t1.id=t2.dato1 AND t3.dato3=t1.id 

GROUP BY dato1 ORDER BY dato1 ASC LIMIT 10";

$sql="SELECT *, dato1, count(dato2)

FROM tabla1 AS t1

LEFT JOIN tabla2 AS t2  ON t1.id=t2.dato1 

GROUP BY t2.dato1 ORDER BY t2.dato1 ASC LIMIT 10";

$sql="SELECT *, dato1, count(dato2)

FROM tabla1 AS t1

LEFT JOIN tabla2 AS t2  ON t1.id=t2.dato1

LEFT JOIN tabla3 AS t3  ON t1.id=t3.dato1

GROUP BY t2.dato1 ORDER BY t2.dato1 ASC LIMIT 10";