Secondary or lesser position. Fiddle is a violin so someone else is in first or the more important position. Used whenever someone has lost previous prominence. (Compare to Take a backseat to or Three’s a crowd.)
“I play second fiddle to her real boyfriend when he comes home from college.”