Light stand that can hold 2 lights?
I don’t know what weight lights you are thinking of, or how far offset from the stand you want, but super clamps with extension arms are definitely the most flexible option.
There is the Manfrotto 6.5 inch joining arm for close to the stand heavy lights, the 237 flex arm, 237HD (heavy duty) flex arm, the snake arm, magic arm, and variable friction magic arm.
If you want something heavier duty, then there is the Avenger D230 grip head which you can use with steel pipe or aluminium bar stock.
If you want to align two lights directly above one another, then you will have to offset the top light too.