Donald Trump's approval rating has fallen to a record low - indicating that next month's midterm elections could be punishing for the Republicans.