President Donald Trump's approval rating has slipped below recent presidents ahead of the midterm elections.