so what value do you not know?
When you create the order, Im guessing you offer the customer the option of either using the existing address from the customers table or whatever delivery address they have specified as part of the order capture process.
but if you must do it another way, you could use an update query, seems daft to do it this way but
as to which customers are active, well define active....
update orders set invoice_addr1 = customers.address_1, invoice_addr2 = customers.address_2
join customers on orders.customer_id = orders.customer_id
presumably an active customer is one wo has purchased something in the last n time periods
...so by using the suitable MySQL datetime function you can find what customers have place and order within the required n time periods by doing a JOIN between the customers and orders table
As a suggestion I'd recommend that you pay attention to your naming of tables and columns. There are nearly as many naming conventions as promises made by a politician in the rn up to an election, wahtg ever convention you do decide to use stick with it. So if you want to abbreviate address to addr, do so, but dont' use addr and address inside the same schema
Either use CamelCase or lower_case_with_underscore but don't mix
there's recommendations that you don't repeat the table name in column names within the same table. so instead of using customer_id inside the customers table use is instead (however do use the table name as a prefix when its a foreign key, it makes it easy to track what column is a foreign key pointing to what table. so customer_id in the orders table is all well and good.
Does your design really only allow a single product per customer order?
there is something odd about your orders table. usually I'd expect customer ordsxers to be modelled as (at least) 2 tables. one for the header information (eg order date, who placed it, delivery addres etc) and one comprising the the items ordered. in the order detail I/d expect there to be (at the very least) the product, the qty ordered the price.
I'd rather be riding on the Tiger 800 or the Norton