mysql遇到的问题

    SELECT ud.uid,u.username,u.`password`,u.email,d.devicename,d.devicetype,`data`.param1,`data`.param2,`data`.param3,`data`.param4,`data`.time
    FROM device d
    LEFT JOIN user_device ud on d.id=ud.did
    LEFT JOIN user u on u.id=ud.uid
    LEFT JOIN `data` on `data`.did=d.id

    INSERT  INTO user_device (
            uid,did
    )SELECT
            (
                    SELECT id 
                    FROM user
                    WHERE user.username="zzes"),
            (
                    SELECT id
                    FROM device
                    WHERE device.devicename="orange pi")
    FROM DUAL
    WHERE NOT EXISTS(
            SELECT uid,did
            FROM user_device
            WHERE uid=(
                    SELECT id 
                    FROM user
                    WHERE user.username="zzes")
            AND
                  did=(
                    SELECT id
                    FROM device
                    WHERE device.devicename="orange pi")
    ) 

    INSERT `data`(did,param1,param2,param3,param4) 
    SELECT 5,23,44,1,1 FROM device WHERE device.id=5

SELECT mobile FROM doctor ORDER BY  id  LIMIT 1'