如何查询多层数组结构

情景：chatExample 表 chatId记录删除，同时删除课程表中 modules模块 cases 中含有 "chatId":"6856be414f8a242a1b4ef999"的记录

{
"desc": "课程01课程01课程01课程01课程01课程01",
"icon": "https://env-00jxto01aqr7.normal.cloudstatic.cn/list1.png?expire_at=1750517149&er_sign=474b41bd26a7400acdc0109f7642f723",
"scope": [
"训练营会员",
"普通用户"
],
"status": true,
"modules": [
{
"id": "94126251-aa0b-4292-8274-0cd23c512df8",
"icon": "https://env-00jxto01aqr7.normal.cloudstatic.cn/list1.png?expire_at=1750517158&er_sign=38fe6402bc6c3b9cfb0f360f412686bb",
"name": "模块01",
"cases": [
{
"id": "64146289-6b0f-448f-bdcf-7e30a309fb67",
"type": "chat",
"chatId": "6856c5ac5afa897d62e72713",
"sectionId": "6856c5ac5afa897d62e72713"
}
]
},
{
"id": "49fc055b-8d79-48e1-a941-fdcf0572e81b",
"icon": "https://env-00jxto01aqr7.normal.cloudstatic.cn/list1.png?expire_at=1750517172&er_sign=ebd0c27a3556e4fe643660c08bb33616",
"name": "模块01",
"cases": [
{
"id": "52b22892-93fc-43df-8cbf-be47f6f2aee0",
"type": "studentCase",
"chatId": "6856be414f8a242a1b4ef999",
"sectionId": "6846f5d8a9557e30cc552574",
"studentCaseId": "6846f5d8a9557e30cc552574"
}
]
}
],
"authCode": "",
"operator": "admin",
"courseName": "课程01",
"updateTime": 1750517209723
}