Canada's Prime Minister has said his country's people are not impressed by the UK offering a second state visit to US President Donald Trump.