How do I list a count from a seperate table next to users in another table?

See more:

PHP

Hi,

I have a users table displayed on a page with their userID and username.

I want to get a count of usernames from a seperate table (Reported Users table) and list the count alongside their respective username and userID.

In the reported table I have a userID and username, and for every time a user is reported, their username is added to the reported users table. I know how to get a count from the reported table but im unsure of how to list the amount of times their username appears in the reported users table next to their username from the users table.

$db = Database::getConnection();
				$query = 'SELECT * FROM users WHERE activated=1';
				$output = $db->query($query);
				$results = $output->fetchAll(PDO::FETCH_ASSOC);
				if (count($results) > 0) {
					echo "<table cellspacing=\"0\">";
					echo "<tr><th>UserID</th><th>Username</th><th>Reported</th></tr>";
					foreach($results as $result){
						echo "<tr>\n";
						$username = $result['username'];
						echo "<td>$result[userID]</td>";
						echo "<td>$result[username]</td>";
						$reportsQuery = "SELECT reported COUNT(*) FROM reports WHERE reported = '$username'";
						$reportsOutput = $db->query($reportsQuery);
						while ($row = $reportsOutput->fetch(PDO::FETCH_ASSOC)){
						echo '<td>Report count</td>';
						}
						echo "</tr>\n";
					}
				} else {
					echo 'There are no active users!';
				}
				echo "</table>";?>