'Drag in' = pull (into the house, etc). Look what the cat dragged in is a jocular remark we use to express dismay at the poor appearance of a person arriving or an undesired person arriving. It is not to be intended or taken seriously.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.