You are correct. "Did you have any idea that John was married?" means "Did you know that John was married?" "Did you have any idea..." is more emphatic while "Did you know..." is a simple question.

I'm sorry, my English is bad. "Did you have any idea?" <<<this sentence means what?

I don't understand which sentence you are asking about.