SELECT
              `us`.`id`               AS `user`,
               `curr`.`code`          AS `currency`,
               `o`.`status`           AS `orderStatus`,
               SUM(o.income_user_aff) AS `amount`
             FROM `user_source` `us` LEFT JOIN `user` `u` ON u.user_source_id = us.id
               LEFT JOIN `click` `c` ON c.user_id = u.id
               LEFT JOIN `order` `o` ON o.click_id = c.id
               LEFT JOIN `currency` `curr` ON curr.id = o.income_currency_id
             WHERE o.id IS NOT NULL
             GROUP BY `u`.`id`