Few people globally have confidence in President Donald Trump's leadership, according to a new poll.