The US Supreme Court has denied President Donald Trump's attempt to restrict mail-in voting ahead of the November midterm elections.