select * from award left outer join user on award.openid = user.openid