為什么使用子查詢，明明數(shù)據(jù)庫(kù)那個(gè)字段是有值的，查出來(lái)卻是空的

這種情況的原因是什么，怎么解決
SELECT

o.order_id,
o.send_goods_status send_goods_status,

FROM

(
    SELECT
        o.order_id,
        mi.STATUS send_goods_status,
    FROM
        ypb_order_info o
    LEFT JOIN ypb_order_merchandiser_mission_info mi ON o.order_id = mi.order_id
    AND mi.create_time = (
        SELECT
            MAX(create_time)
        FROM
            ypb_order_merchandiser_mission_info
        GROUP BY
            id
        ORDER BY
            create_time DESC
        LIMIT 1
    )
) o

GROUP BY

o.order_id

ORDER BY

o.create_time DESC

send_goods_status為空，但我查了表是有數(shù)據(jù)的。
我的目的是查出ypb_order_merchandiser_mission_info這張表的每個(gè)訂單對(duì)應(yīng)多條，但我只取最新的一條