关于left join 查询软删除数据表，删除条件应当在on中而不是全局

[darkicerain]

Go version

go1.25.3

GoFrame version

v2.10.0

Can this bug be reproduced with the latest release?

Option Yes

What did you do?

我的go 代码
`model := dao.CmsContent.Ctx(ctx).As("t")
model = model.LeftJoin("xy_cms_content_type content_type", "content_type.id = t.content_type_id")
model = model.LeftJoin("xy_cms_page_template page_template", "page_template.id = t.template_id")
model = model.LeftJoin("xy_member member", "member.id = t.author_id")
model = model.LeftJoin("xy_member created_member", "created_member.id = t.created_by ")
model = model.LeftJoin("xy_member updated_member", "updated_member.id = t.updated_by ")
model = model.Fields("t.*")
model = model.Fields("content_type.name as contentType_name")
model = model.Fields("page_template.name as template_name")
model = model.Fields("member.nickname as author_nickname")
model = model.Fields("created_member.nickname as createdBy_nickname")
model = model.Fields("updated_member.nickname as updatedBy_nickname")

var item adminin.CmsContentViewModel
err := model.Where("t.id", id).Scan(&item)`

What did you see happen?

SELECT t.*,
content_type.name as contentType_name,
page_template.name as template_name,
member.nickname as author_nickname,
created_member.nickname as createdBy_nickname,
updated_member.nickname as updatedBy_nickname
FROM "xy_cms_content" AS t
LEFT JOIN "xy_cms_content_type" content_type ON (content_type.id = t.content_type_id)
LEFT JOIN "xy_cms_page_template" page_template ON (page_template.id = t.template_id)
LEFT JOIN "xy_member" member ON (member.id = t.author_id)
LEFT JOIN "xy_member" created_member ON (created_member.id = t.created_by)
LEFT JOIN "xy_member" updated_member ON (updated_member.id = t.updated_by)
WHERE ("t"."id" = 463)
AND "t"."deleted_at" = 0
AND "member"."deleted_at" = 0
AND "created_member"."deleted_at" = 0
AND "updated_member"."deleted_at" = 0
LIMIT 1

What did you expect to see?

SELECT t.*,
content_type.name as contentType_name,
page_template.name as template_name,
member.nickname as author_nickname,
created_member.nickname as createdBy_nickname,
updated_member.nickname as updatedBy_nickname
FROM "xy_cms_content" AS t
LEFT JOIN "xy_cms_content_type" content_type ON (content_type.id = t.content_type_id)
LEFT JOIN "xy_cms_page_template" page_template ON (page_template.id = t.template_id)
LEFT JOIN "xy_member" member ON (member.id = t.author_id)
LEFT JOIN "xy_member" created_member ON (created_member.id = t.created_by AND "created_member"."deleted_at" = 0)
LEFT JOIN "xy_member" updated_member ON (updated_member.id = t.updated_by AND "updated_member"."deleted_at" = 0)
WHERE ("t"."id" = 463)
AND "t"."deleted_at" = 0
AND "member"."deleted_at" = 0
LIMIT 1

[waterWang]

PR #4816 submitted.

For LEFT JOIN queries, the soft delete condition (deleted_at = 0) was previously added to the WHERE clause, which turns the LEFT JOIN into an INNER JOIN — filtering out rows from the main table when the joined table has no matching row.

The fix detects LEFT JOINs and injects the soft delete condition into the ON clause instead, preserving the LEFT JOIN semantics.