Just for the case

gistfile1.sql

SELECT 
`broker_id`, 
`account_number`, 
`account_id`, 
EXTRACT(YEAR_MONTH FROM `payment_date`) AS `yyyymm`, 
SUM(`amount_total`) AS `sum_amount_total`, 
SUM(`amount`) AS `sum_amount` 
FROM `lk_withdrawals` 
WHERE 
(`user_id`=1) AND (`status`=1) 
GROUP BY 
`broker_id`, `account_number`, `yyyymm` 
ORDER BY 
`broker_id`, `account_number`, `yyyymm` DESC

SELECT 
`broker_id`, 
`bill_number`, 
EXTRACT(YEAR_MONTH FROM `order_date`) AS `yyyymm`, 
SUM(`profit`) AS `sum_profit`, 
SUM(`comission`) AS `sum_comission` 
FROM `lk_stats` 
WHERE 
(`bill_number` IN ('396924', '1332705', '347932', '123456')) AND (`broker_id` IN (1, 2, 3, 5)) 
GROUP BY 
`broker_id`, `bill_number`, `yyyymm` 
ORDER BY 
`broker_id`, `bill_number`, `yyyymm` DESC