How to join sqlite (or other) database elements?

Question

Database

Pts stupid question, because I didn’t study database theory, but I can’t understand now:
there is a database, a table in the format:
id | name | link
1 | cow | 2.3
2 | sheep | 1
3 | frog | 2.1

There is more data, but they are out of scope.
Well, i.e. associate 1 element with a number of others in this base. How to do it most efficiently? because the current version: a string that is parsed into an array is such an occupation)