查询符合名字中含123123的人在b表的所有记录

SELECT
    * 
FROM
    ecs_qingkuan_apply 
WHERE
    1 = 1 
    AND apply_uid IN ( SELECT user_id FROM ecs_users WHERE user_name LIKE '%123123%' ) 
ORDER BY
    apply_time DESC;