Lead to Order Table design
One of the of goals of a relational database is to eliminate double storage of data. If you can find the right User for the Lead through the Order then you can leave out the reference in one of the tables (they are always the same as you mentioned in a comment). Keeping it in both tables makes your application more complicated.