The author of a tell-all book about Donald Trump has told Sky News his presidency "clearly... doesn't work".