diff --git a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml
index e43cdcf..267638d 100644
--- a/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml
+++ b/newfiber-termites/newfiber-termites-dataup/src/main/resources/mapper/termite/TermiteMapper.xml
@@ -31,12 +31,12 @@
         ta.create_time as createTime
         FROM
         `ter_device_info` ta
-        JOIN ter_project_user pu ON ta.project_code = pu.project_code
+        <include refid="Join_Table"/>
         LEFT JOIN ter_device_monitoring_data_realtime tb ON ta.sn = tb.sn
       where 1=1 and ta.del_flag = 0
-        <if test="request.userId != null and request.userId != ''">
-            and pu.user_id = #{request.userId}
-        </if>
+<!--        <if test="request.userId != null and request.userId != ''">-->
+<!--            and pu.user_id = #{request.userId}-->
+<!--        </if>-->
         <if test="request.projectName != null and request.projectName != ''">
             and pu.project_name  like concat('%',#{request.projectName},'%')
         </if>
@@ -82,6 +82,13 @@
 
     </select>
 
+    <sql id="Join_Table">
+        <if test="request.userId != null and request.userId != ''">
+            and pu.user_id = #{request.userId}
+        </if>
+        INNER JOIN ter_project_user pu ON ta.project_code = pu.project_code AND pu.user_id = #{request.userId}
+    </sql>
+
     <update id="updateMonitorDevice">
         UPDATE `ter_device_info`
         SET