President Donald Trump's approval rating has fallen to a new low in another poll as the midterms are just weeks away.