What's the structure of a matchmaking server?
Try this:-

SELECT id
      ,title
      ,DESCRIPTION
      ,max_players
      ,host_username
      ,host_ip
      ,(
           SELECT COUNT(*)
           FROM   matches_players
           WHERE  match_id = id
       ) AS player_count
FROM   matches