SELECT u.role_id, u.phone, u.email, u.first_name, u.second_name, u.third_name, u.login, u.password_hash, u.division_id, u.created_at::varchar, u.updated_at::varchar,
m.id
FROM users u
JOIN (SELECT ma1.head_manager_id as user_id, ma1.id FROM machines ma1
      UNION
      SELECT ma2.operator_id, ma2.id FROM machines ma2
      UNION
      SELECT ma3.service_technician_id, ma3.id FROM machines ma3
      UNION
      SELECT ma4.manager_id, ma4.id FROM machines ma4) m ON m.id = u.id

SELECT *
FROM machines m
JOIN users u4 ON u4.id = m.service_technician_id
JOIN user_roles ur4 ON ur4.id = u4.role_id
JOIN permissions p ON json_array_elements(ur4.permissions::json)::text::int = p.id

SELECT *
FROM permissions p, machines m
JOIN users u4 ON u4.id = m.service_technician_id
JOIN user_roles ur4 ON ur4.id = u4.role_id
JOIN json_array_elements(ur4.permissions::json) ur4p ON ur4p::text::int = 1

SELECT *
FROM machines m
JOIN users u4 ON u4.id = m.service_technician_id
JOIN user_roles ur4 ON ur4.id = u4.role_id
JOIN json_array_elements(ur4.permissions::json) ur4p ON ur4p::text::int > 1
JOIN permissions p ON p.id = ur4p::text::int