Orm table connection query, specify the query field, the error field is blurred

[tuye01]

1. What version of Go and system type/arch are you using?

go1.17 windows/386

2. What version of GoFrame are you using?

v2.5.0

3. Can this issue be re-produced with the latest release?

v2.5.1仍存在

4. What did you do?

	err := dao. TInfIdpClient.Ctx(ctx).
		Fields(dao. TInfIdpClient.Columns(). Id, dao. TInfIdp.Columns(). NameCn, dao. TInfIdp.Columns(). SourceType).
		LeftJoin(dao. TInfIdp.Table(), "idp", "t_inf_idp_client.idp_id =idp.id").
		Where(dao. TInfIdp.Columns(). Deleted, consts. DataDeletedFalse).
		Where(dao. TInfIdp.Columns(). Enabled, consts. DataEnabled).
		Scan(&idpData)
	if err != nil {
		return nil, err
	}

sql：

SELECT `id` FROM `t_inf_idp_client` LEFT JOIN `t_inf_idp` AS `idp` ON (t_inf_idp_client.idp_id =idp.id) WHERE 
        (`t_inf_idp_client`.`deleted`=0) AND (`t_inf_idp_client`.`enabled`=1)

error message：Column 'id' in field list is ambiguous

5. What did you expect to see?

1.连表中的关联关系使用代码生成的字段变量对比
LeftJoin(dao. TInfIdp.Table(), "idp", "t_inf_idp_client.idp_id =idp.id")
==》
LeftJoin(dao. TInfIdp.Table(), dao. TInfIdpClient.Columns(). IdpId==dao. TInfIdp.Columns(). Id).
2.连表时可指定查询 某个表中的字段

6. What did you see instead?

[gqcn]

@tuye01 Please use like this:

err := dao.TInfIdpClient.Ctx(ctx).
	FieldsPrefix(dao.TInfIdpClient.Table(), dao.TInfIdpClient.Columns().Id).
	FieldsPrefix(dao.TInfIdp.Table(), dao.TInfIdp.Columns().NameCn).
	FieldsPrefix(dao.TInfIdp.Table(), dao.TInfIdp.Columns().SourceType).
	LeftJoinOnFields(dao.TInfIdp.Table(), "idp", "=", "id").
	Where(do.TInfIdp{
		Deleted: consts.DataDeletedFalse,
		Enabled: consts.DataEnabled,
	})
	Scan(&idpData)
if err != nil {
	return nil, err
}