给今天过生日的用户发放50枚
INSERT INTO coin_trade (coin_amount, subject, word, user_id, trade_time, goods_id)
SELECT#插入的每条数据来自于这个select查到的二维数组
'50',
(SELECT goods_name
FROM goods
WHERE goods_id = 19
LIMIT 1),
'Happy Birthday!',
user_id,
now(),
19
FROM users
WHERE
date_format(birthday, '%m-%d')