mysql field cb2

Yes, you'll need 2 fields. 1 for edit display (your query select) and 1 for profile display (the query field). The reason for this is you are not storing to CB the team logo as the select fields value so you need to grab it using cb query field. So if you're storing the team id then your query would be the below.

Field Name: cb_team_logo
Query: Output: Single Row
Columns: Multiple Columns
Display: Custom
Custom:
cb_team being your query select field where they've selected a team. Your query select would be configured as follows.

Field Name: cb_team
Query: Value Column: id
Label Column: name

thanks, I forgot to say I figured it out exactly like you said.

uhm there is an easy way to avoid broken images if the team doesn't have a logo? (the db field is empty)

If you're using latest CB Query Field there shouldn't be broken images as it won't output anything if the query returns no results. If you mean that there is a result, but no logo yet then you need to add to your query WHERE statement to check that there's a logo. Example as follows.

thanks, but in this way I don't see the field at all.
Here the situation: some teams have the logo, some other doesn't.
In case they don't have it I want to show the team name.

You can't have substitution IF statements on extra substitutions (so the columns can't be used in IF substitutions). So what you're wanting isn't possible without a 3rd field. The 3rd field would purely be querying for a logo. This would allow you to condition off that 3rd field so you could do something like the below.

Field Name: cb_team_logo_url
Query: Output: Single Row
Columns: Single Column

The above would output the logo URL. Place it on a tab in a not shown on profile position so it can be used for substitutions only as needed. Next in cb_team_logo you should be able to adjust the custom output as follows.

FROM: TO:
Please understand the above is just an example. I've no idea your database structure so I've no idea if the queries will even work. I have not tested the above. You may need to make adjustments.

An alternative is to edit your query and have the query it self format the <img tag, which would eliminate the need for a 3rd field.