"I do not know who the man standing at the door is." Is the correct wording for this sentence when you are making a statement about the man at the door.
You would use "Who is the man standing at the door?" When asking someone a question in order to find out who the man is.
I hope this helps!