How to implement a list in a database?

Question

MySQL

Hello.
Tell me how to correctly implement the structure of the database, which database is best suited for this task, and how best to tune it for performance.
Now everything looks something like this: there is a large table of users users, which includes a variety of information (id, full name and other characteristics). There is a table with lists of lists that these users can be members of. This table consists of 2 fields: the id of the list and a string that includes the id of the users that are in this list (string example: [1, 2, 18, 10]).
The task is that I need to display lists of users (take information about the user from the users table). The list can include 1000 or more users. How it is better to implement it? Is it possible that the database should be completely in RAM? It may be necessary to use caching for frequently requested data. Or maybe the structure of the database can be improved? Also, what is the best way to select 1000 or more records from the database for a specific value of the primary key id?

Answer 1

1000 entries is nothing. do it on any DBMS, everything will work fine