select * from base_user where right(convert(varchar(10),birthday,20),5) >= right(convert(varchar(10),getdate(),20),5) and 
right(convert(varchar(10),birthday,20),5) < right(convert(varchar(10),dateadd(day,10,getdate()),20),5)
order by birthday