Update the table attribute by matching foreign key from one table to the foreign key of another table

I have one table named employee_profile another table named employee_office which has a foreign key employee_profile_id and i have one more table named salary_increment which has foreign key employee_profile_id.

i gave dropdown list in salary increment section which fetches the employee names from employee_profile table.

the question is how can i update the basic salary in employee_office table when user enters salary increment.

i am new in yii2 and i can’t find the perfect answer for this.