Setting an object's rotation so that it faces two objects

I’m trying to set up my own particles via nodes, I want the particle planes to always face the camera, but also another especific location, for example a spark that faces the camera with the Z axis and it’s velocity with the Y axis.
How could I do this?
I can set this up when any rotation that aligns one axis with the camera is valid, like a round particle, with the looking at node.