Query problems in mysql

Question

Good afternoon. I have a query in my db that has to bring the user name data and his id of the users table and the commission table brings the commission , prize, month, and a month field consisting of year and month ex 201801.

my query is this.

select u.nome, u.id as id_user, c.*
from usuarios u 
left join comissao c on c.id_usuario=u.id
where (c.mes='".dias($dia,'mes-anotoanomes')."' or c.mes IS NULL) and id_grupo='$resultg[id]' and acesso='1'
order by u.nome asc;

where the function dias($dia,'mes-anotoanomes') will convert the date of the variable coming day so 01-2018 to 201801.

It turns out that when there is no information in the commission table that query works. only that when recording month 1 data for ex when I will select another month for ex month 02-2018 it returns nothing

follows ss from my tables

could anyone assist me with this query ? Thank you .

Answer 1

solved transforming this query into 4 querys being 3 subs

select 
                                    u.nome, u.id as id_user,
                                    (select comissao from comissao where id_usuario=u.id and mes='".dias($dia,'mes-anotoanomes')."') as comissao,
                                    (select premio from comissao where id_usuario=u.id and mes='".dias($dia,'mes-anotoanomes')."') as premio,
                                    (select meta from comissao where id_usuario=u.id and mes='".dias($dia,'mes-anotoanomes')."') as meta
                                    from usuarios u where u.id_grupo='$resultg[id]' and acesso='1'
                                        order by u.nome asc