我的应用程序有4个表：
员工->公司->附加->债务
我需要生成以下工资收据：
收据示例
在这个文件上，我必须显示所有歧视性的信息，如工资及其价值和费用。最后是额外资产和债务之间的净值。
我举了个例子：

$total_additional= 0;
$total_debt= 0;

// Here in employees contains a join between employees and companies
foreach ($employees as $employee) {

  foreach ($additionals as $additional) {
    if ( $employee->id == $additional->employee_id ) {
     //Print the additional reference
     $total_additional += $additional->value;
    }
  }

  foreach ($debts as $debt) {
    if ( $employee->id == $debt->employee_id ) {
     //Print the debt reference
     $total_debt += $debt->value;
    }
  }

  // Here should come the net value

}

如何进行查询以获取这些结果？