Mick Mulvaney, who previously served as President Donald Trump's chief of staff, told CNBC's "Squawk Box" Thursday he is resigning from his current role as special envoy to Northern Ireland following the assault on the Capitol by pro-Trump protestors.