Sql queries 10 pieces of data for each category

a table

b table

b_id name a_id
1    a    1

2    b    1

3    c    1

4    d    2

5    e    2

how to write the sql statement to query 10 pieces of data for each category

find an array structure similar to the following:

array(
    array(
        "a_id"=>1,
        "a_name"=>1
        "b_list"=>array{
            array(
                "b_id"=>1,
                "b_name"=>a,
                "a_id"=>1,
            ),
            
            array(
                "b_id"=>1,
                "b_name"=>a,
                "a_id"=>1,
            ),
        }
    },
    array(
        "a_id"=>1,
        "a_name"=>1
        "b_list"=>array{
            array(
                "b_id"=>1,
                "b_name"=>a,
                "a_id"=>1,
            ),
            
            array(
                "b_id"=>1,
                "b_name"=>a,
                "a_id"=>1,
            ),
        }
    },
);

I"m not sure if this structure can be checked by mysql. How efficient is it? I want to toss about (A V A)

Php mysqli

Mar.24,2022

A way of using grouping and trickery
SELECT * FROM b WHERE b.id in (
SELECT GROUP_CONCAT (b.id) FROM an INNER JOIN b on a.id = b.aid GROUP BY a.id HAVING COUNT (*) < 11
)

The idea of

is to get 10 id of the b table of the group, then look it up in the model text, and finally get 10

of each group.

if it is up to date, sort it using

UNION query?

Previous: Is the model layer in the PHP framework equivalent to model+dao+service? in other languages?

Next: Use the typescript+vue project to get a red alert in the vscode editor?

Use mariadb (mysql) php to write an api for your own use.
the api I am talking to now is a request from others. is to use curl to catch the opposite party http. I give it to the opposite party json , and then the opposite party gives back to me json, and then I show it (using mongodb, nodejs) ). it s just t...

Php7 php mysqli mysql mariadb

Mar.04,2021
Php execution sql file is garbled and incomplete
I want to read the sql file through php to create the database and write some initial data, so I wrote the following php code and sql after the first floor hint, the code has run array (size=5) 0 => string CREATE DATABASE IF NOT EXISTS wishwall...

Php mysqli

Mar.24,2021
The idea that a commodity has a sub-commodity?
I would like to ask if there are multiple sub-items in a main commodity multiple sub-items will have their own inventory how can the database plan correctly? main commodity prod_id stock price 1 0 0 2 0 0 3 0 0 4 10 30 Sub-merc...

Php7 php mysqli mysql

Nov.20,2021