How to write sql query

I need something like

```
Insert Into database.table (userID,credID,time) 
values 
userId = for all in (10,15,12,17,14,267,16,689,18,7659,20)
credID = for all in (1,2,3,4,5) 
time = constant (forall the same) 

```

now database structure

userID,credID,time
10,34,2013-12-12
10,54,2013-12-12

so i must get

```
userID,credID,time
10,34,2013-12-12
10,54,2013-12-12
10,1,2013-12-12
10,2,2013-12-12
10,3,2013-12-12
10,4,2013-12-12
10,5,2013-12-12
11,1,2013-12-12
11,2,2013-12-12
11,3,2013-12-12
11,4,2013-12-12
11,5,2013-12-12
....

```

for logical algoritm must be like

for each userID in range (10,11,12,13,14,15,16,17,18,19,20)
insert new fields with credID values (1,2,3,4,5) 

For single userID i can create single credID with query 
`insert into database.table (userID,credID,time) values (10,1,2013-12-12)` 
but i need to insert multiple credID for multiple userID