Trump's approval rating has fallen to its lowest level of his second term, raising pressure on Republicans ahead of the US midterms.